Use same UserForm
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.
David Hager
Excel MVP
"Soniya" wrote in message
...
Hi all,
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?
TIA
Soniya
|