#1
|
|||
|
|||
IF Statement to custom Drop-down Field
Hi I am creating a form in word 2010 and I am using lots of drop down boxes.
Basically what I need is if the user selects an option from the first drop down box the second box will then provided options relating to the answer in box 1. EG: if Sales is selected in box 1 a list of names of the sales staff will be in box 2 but if HR is selected in box 1 box 2 will have a life of the HR staff. Please help! |
#2
|
||||
|
||||
See attached. What you've described requires a ContentControlOnExit macro, which you'll find in the document's 'ThisDocument' module. The conditional text for each dependent option is held as comma-delimited strings in the 'StrOut' variable populated by the 'Select Case' statement.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you so much for your help!
I will shout if I get stuck but it seems as though your have hit the nail on the head! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form Field Drop Down List | James Ayers | Word | 3 | 07-14-2013 07:53 PM |
DRop down list within text of If statement | sbarron76 | Mail Merge | 2 | 05-03-2013 05:00 AM |
Mail merge will not format date field generated by Excel IF statement | borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
Form Fields - Create blank form text field with if statement? | LAssist2011 | Word | 5 | 12-14-2011 03:02 PM |
Outlook 2007, contacts: drop down in custom field | pacecal | Outlook | 0 | 06-16-2009 10:43 AM |