|
|
#1
11-03-2013, 11:43 PM
|
|||
|
|||
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
11-04-2013, 01:23 AM
|
||||
|
||||
|
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
11-04-2013, 02:11 AM
|
|||
|
|||
|
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 |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
