Sending a parameter to a Userform
Dave Scott wrote:
Is there a way to pass a parameter to a Userform (similar to openargs in an
access form)?
I have a calendar (Userform) that returns a date. I want the calendar to be
initialized with the parameter date or with today's date if the parameter
value is empty.
Dave
userform1 code
-------------
public myInput as variant
public myOutput as variant
main module
-------------
load userform1
userform1.myInput = "something"
userform1.show
a = userorm1.myOutput
unload userform
at the end of userform, when user clicks ok, you should hide userform
(don't unload it).
you can replace variables by properties defined by you.
|