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?

dynamic form updates
 

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?

dynamic form updates
 

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." wrote in message
...
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?