Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-12-2013, 04:15 AM
ali212006 ali212006 is offline Multiple Drop Down Lists in word Windows 7 64bit Multiple Drop Down Lists in word Office 2010 32bit
Novice
Multiple Drop Down Lists in word
 
Join Date: Mar 2013
Posts: 3
ali212006 is on a distinguished road
Default Multiple Drop Down Lists in word

Hi



I am more of an excel user but i have a form to update at work and it requires the creationof drop down lists.

I finally figured out how to create the first one but now what I need to do is this:

when I select an option from the 1st drop down I need it to give me optiopns for the 2nd drop down.

For example the 1st drop down would have business units so wheni select a business unit i want it to show me the breakdown of individual departments ie legal, benefits, consultancy etc, but if I pick another it might have different departments.

I dont want to use macros if I can help it becasue I am not confident with them.

Any help please
Reply With Quote
  #2  
Old 03-13-2013, 07:36 AM
OTPM OTPM is offline Multiple Drop Down Lists in word Windows 7 32bit Multiple Drop Down Lists in word Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
If you are more familiar with Excel then have you considered creating the drop down's in Excel then embedding the Excel worksheet in your Word document. You can then double click the Worksheet in your Word document to make your selections then click out side the worksheet in your Word document to deactivate the spreadsheet.
If you need any help with this then let me know.
Hope this helps.
Tony
Reply With Quote
  #3  
Old 03-13-2013, 07:43 AM
ali212006 ali212006 is offline Multiple Drop Down Lists in word Windows 7 64bit Multiple Drop Down Lists in word Office 2010 32bit
Novice
Multiple Drop Down Lists in word
 
Join Date: Mar 2013
Posts: 3
ali212006 is on a distinguished road
Default

Thanks for coming backl to me. I am not sure how to do this - would you mind helping?
Reply With Quote
  #4  
Old 03-13-2013, 12:16 PM
OTPM OTPM is offline Multiple Drop Down Lists in word Windows 7 32bit Multiple Drop Down Lists in word Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Follow this link. If you need further help then come back to me on the forum.
http://office.microsoft.com/en-gb/wo...20810.aspx#BM4
Tony
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Dependent drop down lists bobbych Word 1 02-08-2013 04:38 PM
Locking Documents and Drop-Down Lists Andrew H Word 2 11-04-2012 02:59 PM
Multiple Drop Down Lists in word Drop-down lists in Excel Maureen Excel 1 11-10-2011 08:11 AM
Dependent drop down lists in Word 2007 benbenasc Word VBA 0 08-24-2011 06:34 AM
Drop Down Lists Browett Excel 0 12-19-2005 04:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:38 AM.


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