![]() |
|
#1
|
|||
|
|||
![]()
So, I'm really confused. When the drop-down menu is XX, I want the exit macro to create a new additional form field. Am I explaining correctly or not?
|
#2
|
||||
|
||||
![]() Quote:
To determine where the dependent text formfield should go, a bookmark is needed. To that end, the document I provided has a bookmark named 'BkMk' at the destination. The macro likewise refers to that bookmark - not the dropdown's bookmark or any other formfield's bookmark. So, if you want to use the macro, you need to do likewise. Your bookmark name doesn't have to be 'BkMk' but, if you decide to use any other name, you must create the bookmark via Insert|Bookmark and edit the macro to refer to that name.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
OK, I finally got it. In the macro that inserts all of this stuff I have to create a bookmark for the new form field to go to. One more question and I'll stop bugging you-I would like to add default text to the new form field. How do I do that? You have been a great help, I have learned much. Too much to learn and so little time-Thanks
|
#4
|
||||
|
||||
![]() Quote:
.FormFields.Add BmkRng, wdFieldFormTextInput the line: BmkRng.FormFields(1).TextInput.EditType wdRegularText, "My default text" where "My default text" is whatever you want for the default.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
![]()
The code works great. With this drop-down though I have three additional form fields that are conditional. I have tried working with the code you wrote and I get several error codes. Suggestions?
Do you have a book/books that I can read on the VBA subject? I have Mastering VBA and on other on and both of them do not define terms etc. that I can understand. Suggestions? Thanks- |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jamal NUMAN | Excel | 16 | 11-15-2022 11:59 PM |
Countif statements | Alaska1 | Excel | 5 | 02-05-2015 07:55 PM |
![]() |
stuwoolf | Excel | 2 | 01-10-2015 01:58 PM |
![]() |
Alaska1 | Excel | 1 | 05-14-2014 08:21 AM |
IF statements that shifts to right. | kent | Excel | 0 | 01-19-2006 02:23 PM |