dynamic form updates

I have a userform in VBA setup the way I need it.
I would like to have 3 different Subs use the form.
When the sub calls the form to show, how can I change the Form Title in the
Blue bar across top, And what a certain label on the form say?

OK I figured out how with Globals but, is there
anyway to do it with out Global Variables?
I can do it with Globals, but would like to stay away from those if possible.

Thanks,

"Shawn G." wrote:

> I have a userform in VBA setup the way I need it.
> I would like to have 3 different Subs use the form.
> When the sub calls the form to show, how can I change the Form Title in the
> Blue bar across top, And what a certain label on the form say?

One way is to store the required userform title and caption for the label in
either two public variables or in a specific worksheet location, before each
sub calls the userform these values are set, and the userform intialize
event loads the values into the form.



--
Cheers
Nigel



"Shawn G." <ShawnG@discussions.microsoft.com> wrote in message
news:B14DB5BC-B88B-44E3-A096-DAF439F93A77@microsoft.com...
> I have a userform in VBA setup the way I need it.
> I would like to have 3 different Subs use the form.
> When the sub calls the form to show, how can I change the Form Title in
the
> Blue bar across top, And what a certain label on the form say?