View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd huttenstine Todd huttenstine is offline
external usenet poster
 
Posts: 260
Default 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