Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textboxes
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 .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textboxes
Jo,
Do a Userform1.Hide instead of a Me.Unload This should preserve the values in the form. -- sb "Jo" wrote in message ... 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textboxes
Hide the userform rather than unloading it. Then you can get the values
from the Textbox. When done, then Unload the userform. -- Regards, Tom Ogilvy "Jo" wrote in message ... 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textboxes
I think you mean
Unload Me or Unload Userform1 rather than Me.Unload -- Regards, Tom Ogilvy "steve" wrote in message ... Jo, Do a Userform1.Hide instead of a Me.Unload This should preserve the values in the form. -- sb "Jo" wrote in message ... 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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textboxes
Tom,
Thanks! Yep! I don't use that very often and forget the syntax... -- sb "Tom Ogilvy" wrote in message ... I think you mean Unload Me or Unload Userform1 rather than Me.Unload -- Regards, Tom Ogilvy "steve" wrote in message ... Jo, Do a Userform1.Hide instead of a Me.Unload This should preserve the values in the form. -- sb "Jo" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForm TextBoxes - Is there a way to format as currency or perce | Excel Discussion (Misc queries) | |||
Send and Receive Data From Web Site Into UserForm TextBoxes | Excel Discussion (Misc queries) | |||
Need help w/ userform with 12 textboxes with data going into colum | Excel Discussion (Misc queries) | |||
UserForm TextBoxes | Excel Discussion (Misc queries) | |||
add numbers in textboxes on userform | Excel Programming |