Help with storing varaible value to use later

[francozola25]

Hello

I was wondering if someone could help me. I have userform with a textbox called textbox1. When the command is clicked i want to be able to use this textbox1 again as a variable in a hyperlink. I was wondering how could i store this as a variable and use it again.

I was looking up Global Variable but i'm not sure if i'm on the right track.

Many Thanks

[mdmackillop]

A few possibilities. Simplest is maybe to pass the text to a label caption on the userform which can be read again when required. The label can be hidden if required.

[Bob Phillips]

If you just hide the form, you can still get at the textbox value from your other code with



Userform1.TextBox1.Text