userform textboxes

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

Is there a way to do this without transfering the values
to the worksheet? Such as declaring my result for
textbox12?
Thanks
Jo

Hi
I am still having problems getting the data from textbox
entries into other modules.
I would like to be able to name userform1.textbox12.value
as txt12 and then have it available to all other macros.
May be I am putting the code in the wrong place?
Thanks agian for all your help.
Jo

..
 
Jo,

Do a Userform1.Hide instead of a Me.Unload
This should preserve the values in the form.
 
Hide the userform rather than unloading it. Then you can get the values
from the Textbox. When done, then Unload the userform.
 
Back
Top