Replace tag with text in a textbox inside the Worksheet
Possible Usage Scenarios
Text boxes can have tags which can be replaced with some text at run time to configure them according to the requirement. Tags can be some labels enclosed in angle brackets ‘<’ and ‘>’. There can be multiple tags within a single textbox.
Following sample code replaces tags TAG_1 and TAG_2 with some text say ‘ys’ and ‘1’. Sample file for testing below code can be downloaded from the following link: