Passing variable values from userforms
Is it possible to pass a value from a variable that is in
a userform? I have a date that a user inputs in a
textbox. This date is stored in a variable. Then when
the user clicks the OK button on the userform, a module is
called. I need that variable fromt he userform to be
accessable from the module. I know its possible to pass
variable values between code modules by using the public
statement, but for some reason I cant get it to work from
a userform to code module. Is this possible?
Thanks
Todd Huttenstine
|