![]() |
|
|
|
#1
|
|||
|
|||
|
You said you had a userform with a dropdown DD1. A userform is a class module with properties, methods and events. If you have a dropdown in your Userform then there is a click event for that dropdown. If you have a command button in the userform then there is a click event for that command button.
Put the code I sent to you in one of those events. Look at the create and employ a userform tips page on my website. |
|
#2
|
|||
|
|||
|
I looked up the definition for user form and it appears that I misspoke. I do not have a user form but a Word doc with form fields in it-my bad. Now it makes sense that I was looking for a class module and other things that i don't have.
So I have a Word doc with form fields, and I want a macro to insert an additional form field if one of the items in a pull-down menu is chosen. Thanks for your help, I have a lot to learn- |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Multiple If statements,
|
Jamal NUMAN | Excel | 16 | 11-15-2022 11:59 PM |
| Countif statements | Alaska1 | Excel | 5 | 02-05-2015 07:55 PM |
Using IF statements
|
stuwoolf | Excel | 2 | 01-10-2015 01:58 PM |
count if statements
|
Alaska1 | Excel | 1 | 05-14-2014 08:21 AM |
| IF statements that shifts to right. | kent | Excel | 0 | 01-19-2006 02:23 PM |