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

S

Soniya

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use same UserForm 4
How do I set focus (and select text) on a text box on a modeless userform? 0
Fun with Userforms!!!! 9
use ComboBox value to select range and then use selected range tocreate a chart 3
Userforms with CommandBar Popups 5
Data Val MultiSelect on Userform? 2
UserForm Functionality 1
Checking a userForm that has not been initialized 4

Top