Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page IF Statement to custom Drop-down Field IF Statement to custom Drop-down Field
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 11-03-2013, 11:43 PM
Sammie0Sue Sammie0Sue is offline IF Statement to custom Drop-down Field Windows 7 64bit IF Statement to custom Drop-down Field Office 2010 64bit
Novice
IF Statement to custom Drop-down Field 		 
Join Date: Nov 2013
Posts: 21
Sammie0Sue is on a distinguished road
Post 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!
Reply With Quote
  #2  
Old 11-04-2013, 01:23 AM
macropod's Avatar
macropod macropod is offline IF Statement to custom Drop-down Field Windows 7 32bit IF Statement to custom Drop-down Field Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
Attached Files
File Type: zip Content Controls - Dependent Dropdown.zip (33.5 KB, 104 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-04-2013, 02:11 AM
Sammie0Sue Sammie0Sue is offline IF Statement to custom Drop-down Field Windows 7 64bit IF Statement to custom Drop-down Field Office 2010 64bit
Novice
IF Statement to custom Drop-down Field 		 
Join Date: Nov 2013
Posts: 21
Sammie0Sue is on a distinguished road
Default
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!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Statement to custom Drop-down Field Form Field Drop Down List James Ayers Word 3 07-14-2013 07:53 PM
IF Statement to custom Drop-down Field DRop down list within text of If statement sbarron76 Mail Merge 2 05-03-2013 05:00 AM
IF Statement to custom Drop-down Field Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
IF Statement to custom Drop-down Field 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:45 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft