Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting value of a public var from a form
I need to pass the value entered on a form to a variable
in a module, have tried severial times and no joy. The variable in the module I am trying to set is public, the form item is a textbox. I am using the on exit event. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting value of a public var from a form
Doesn't
myVar = Textbox1.Text not work? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dave D" wrote in message ... I need to pass the value entered on a form to a variable in a module, have tried severial times and no joy. The variable in the module I am trying to set is public, the form item is a textbox. I am using the on exit event. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting value of a public var from a form
No it does not, I have tried from the form ti set the
value and from the module to set the value. Could it be the "private" declaration of the event? -----Original Message----- Doesn't myVar = Textbox1.Text not work? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dave D" wrote in message ... I need to pass the value entered on a form to a variable in a module, have tried severial times and no joy. The variable in the module I am trying to set is public, the form item is a textbox. I am using the on exit event. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting value of a public var from a form
Doing it from a form should be no problem as long as the variable is in a
standard code module. Doing it from the module would need myVar = Userform1.Textbox1.Text and the form must not have been unloaded. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... No it does not, I have tried from the form ti set the value and from the module to set the value. Could it be the "private" declaration of the event? -----Original Message----- Doesn't myVar = Textbox1.Text not work? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dave D" wrote in message ... I need to pass the value entered on a form to a variable in a module, have tried severial times and no joy. The variable in the module I am trying to set is public, the form item is a textbox. I am using the on exit event. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting value of a public var from a form
The variable should be declared Public at the top of the general module,
before any procedures and not within a procedure and not in the code module associated with the form. -- Regards, Tom Ogilvy wrote in message ... No it does not, I have tried from the form ti set the value and from the module to set the value. Could it be the "private" declaration of the event? -----Original Message----- Doesn't myVar = Textbox1.Text not work? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dave D" wrote in message ... I need to pass the value entered on a form to a variable in a module, have tried severial times and no joy. The variable in the module I am trying to set is public, the form item is a textbox. I am using the on exit event. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up a form | Excel Discussion (Misc queries) | |||
How do I setup a kiosk type form for public entry? | Excel Worksheet Functions | |||
Setting up a Form | Excel Discussion (Misc queries) | |||
Setting up MS Excel form | Excel Worksheet Functions | |||
InitializeComponent() errors, Setting values in another form | Excel Programming |