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