Re Post: Use the Same UserForm for several action..
 

Hi all,
I got the following reply ....

You can set the Tag property of the CommandButton when
the procedure is run.
Then, use a Select Case statement to use this value to
obtain the desired
action.

...... for this prev post..


Is it possible to use the same UserForm for several
actions?
For eg. I have a userform with a TextBox and Two
commandButons "OK" and "Cancel"

I am using several macros in which the action when
clicking OK button is different but the design of the
UserForm is same. so in order to perfom these action I
have created several UserFoms which look like the same.

Is there a way that i can use the same userfom and
perform the action based on the sub routine from which it
is called?


Can some one be more specific with an eg. if possible how
can i achieve this..

TIA
Soniya



TIA
Soniya