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. |
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. |
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. . |
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. . |
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. . |
All times are GMT +1. The time now is 04:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com