Question Use variable between HTML tags

[byTimber]

I hope this is the right place to post this question:
TextBox1 is Rich Text:-

I want to replace my String ("Evidence required of this please" ) in this code 1) following which works fine, with a variable (textToPaste) as in code 2) which doesn't work.

1) TextBox1 = "<div><font style=""BACKGROUND-COLOR:#FFFF00"">Evidence required of this please</font>"

2) TextBox1 = "<div><font style=""BACKGROUND-COLOR:#FFFF00"">textToPaste</font>"

Can I persuade the statement to accept "textToPaste" as a variable and not a normal string? - I probably mean - Can You??!
Thanks for looking....

 

[pbaldy]

Try

TextBox1 = "<div><font style=""BACKGROUND-COLOR:#FFFF00"">" & VariableName & "</font>"

 

[byTimber]

Thanks Paul - tried, tested and SORTED!!!

Very fast response and I'm very grateful...... Roger ...

 

[pbaldy]

Happy to help Roger!