|
Posted to microsoft.public.excel.programming
|
|
|
TextBox value
Great,
Thanks.
"Leith Ross" wrote
in message ...
Hello AD108,
Once the UserForm is closed, all the variables, objects and constants
are destroyed. You can choose to save the textBox text to a Worksheet
cell and reload the TextBox when the UserForm is Activated. If you wish
not to have it on a Worksheet you can save it to the registry using the
SaveSetting command and reload the TextBox at anytime using the
GetSetting command. The last choice and most involved would be to
create a file to hold the text.
Sincerely,
Leith Ross
--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=552886
|