Returning a value from a form

[Blue Aardvark]

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

[Bob Phillips]

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" <BlueAardvark@discussions.microsoft.com> wrote in message
news:D8079DF7-BF48-48F9-B256-FE05D178EC67@microsoft.com...
> 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

[Blue Aardvark]

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" <BlueAardvark@discussions.microsoft.com> wrote in message
> news:D8079DF7-BF48-48F9-B256-FE05D178EC67@microsoft.com...
> > 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
>
>
>

[Bob Phillips]

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" <BlueAardvark@discussions.microsoft.com> wrote in message
news:F1011392-B9F0-4390-9B3E-C50929EDA0C2@microsoft.com...
> 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" <BlueAardvark@discussions.microsoft.com> wrote in
message
> > news:D8079DF7-BF48-48F9-B256-FE05D178EC67@microsoft.com...
> > > 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
> >
> >
> >