Returning a value from a form
No, because a Userform is not a method, whereas MsgBox is. A Userform is a
class module, so you can set a Public property within that and read it on
exit with
Userform1.myVar
but for this you cannot unload the userform, you have to hide it (Otherwise
the property is unloaded with it).
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Blue Aardvark" wrote in message
...
Thanks. Thats nice and simple. But is there no slick way of doing it? Or
do
the inbuilt dailogs do exactly the same thing, but just hide the public
variable away.
"Bob Phillips" wrote:
Create a Public variable in a standard code module, set that in the
userform, read it after exiting the userform.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Blue Aardvark" wrote in
message
...
Hello
I would like a form I have built to return a value to the sub that
called
it. The built in dialog boxes, like the OK/Cancel one do this. Anyone
know
how this can be achieved?
Thanks,
Steve
|