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

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

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

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