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 runtime to configure them according to requirements. Tags are labels enclosed in angle brackets ‘<’ and ‘>’. There can be multiple tags within a single textbox.

Sample Code

The following sample code replaces tags TAG_1 and TAG_2 with some text, say ‘ys’ and ‘1’. A sample file for testing the code below can be downloaded from the following link:

sampleReplaceTagWithText.xlsx