How to use value into userform... (2000 sr 1)

[sal21]

... i have userform with a listbox filled with valriuos items...
if i hide or unload userform is possible to use the value of items into listbox?

wath is the command?

[sdckapr]

You can store it in a cell or a variable (global) before you unload it: or after you click on it:

<pre>Worksheets(1).Range("A1") = ListBox1.Value</pre>

or
<pre>sValue = ListBox1.Value</pre>




Steve

[sal21]

... but if i use thsi command

myuserform.hide

the value in listxbox, after this command are still available?

[sdckapr]

If you hide it, is is still available via code.
msgbox myuserform.listbox1.value

or put into a variable
dim sVariable as string
sVariable = myuserform.listbox1.value

Note: If you unload the userform (which was part of what you asked initially) it is not available in code and must be stored somewhere before unloading it.

Steve