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