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.

Sample Code

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:

sampleReplaceTagWithText.xlsx