Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2016, 07:58 AM
Marvel Marvel is offline Cascading List Word 2010 Windows 7 32bit Cascading List Word 2010 Office 2010 32bit
Novice
Cascading List Word 2010
 
Join Date: Apr 2016
Posts: 5
Marvel is on a distinguished road
Default Cascading List Word 2010

Hi


I'm new to using VBA but i want to create a cascading List and am not sure how to.

I need three boxes that are dependent on what is selected in the first box

First Box - Name
2nd Box - Work No
3rd Box - Personal No

I need to be able to select the persons name and in box 2 and 3 it only show me the numbers for that engineer to select from

Thank you
Reply With Quote
  #2  
Old 04-01-2016, 11:24 AM
gmaxey gmaxey is offline Cascading List Word 2010 Windows 7 32bit Cascading List Word 2010 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Does a selected engineer have more than one work or one personal phone number that you need to select from or do you just need to display his or her unique work or phone number?
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #3  
Old 04-01-2016, 05:35 PM
macropod's Avatar
macropod macropod is online now Cascading List Word 2010 Windows 7 64bit Cascading List Word 2010 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,367
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, for example:

Dependent Dropdown Content Controls (for where there are dependencies to choose from)
https://www.msofficeforums.com/word-vba/24661-help-cascading-dropdown-list.html#post77762

Dependent Text Content Controls (for where there are no dependencies to choose from)
https://www.msofficeforums.com/word-vba/16498-multiple-entries-dropdown-lists.html#post46903
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 04-02-2016, 04:55 AM
gmaxey gmaxey is offline Cascading List Word 2010 Windows 7 32bit Cascading List Word 2010 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

I had forgotten about this tips page:
http://gregmaxey.com/word_tip_pages/...down_list.html
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #5  
Old 04-14-2016, 09:14 AM
Marvel Marvel is offline Cascading List Word 2010 Windows 7 32bit Cascading List Word 2010 Office 2010 32bit
Novice
Cascading List Word 2010
 
Join Date: Apr 2016
Posts: 5
Marvel is on a distinguished road
Default

Hi gmaxey

Yes the engineers have one personal number and one work number. Both need to appear on the form when you select the engineer

Thanks
Reply With Quote
  #6  
Old 04-14-2016, 02:40 PM
gmaxey gmaxey is offline Cascading List Word 2010 Windows 7 32bit Cascading List Word 2010 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Everything you need should be available in the links provided.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #7  
Old 04-22-2016, 05:48 AM
Marvel Marvel is offline Cascading List Word 2010 Windows 7 32bit Cascading List Word 2010 Office 2010 32bit
Novice
Cascading List Word 2010
 
Join Date: Apr 2016
Posts: 5
Marvel is on a distinguished road
Default

Hi
Thank you, i have managed to create the links that i need. Only one problem i now have is when i restrict the editing i am unable to edit any of the rest of the form.

I need to be able to change other parts of form which do not have these dropdowns in. can anyone help?

Thanks
Reply With Quote
  #8  
Old 04-22-2016, 06:18 AM
gmayor's Avatar
gmayor gmayor is offline Cascading List Word 2010 Windows 10 Cascading List Word 2010 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Content controls do not require the document to be protected.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #9  
Old 04-22-2016, 06:22 AM
Marvel Marvel is offline Cascading List Word 2010 Windows 7 32bit Cascading List Word 2010 Office 2010 32bit
Novice
Cascading List Word 2010
 
Join Date: Apr 2016
Posts: 5
Marvel is on a distinguished road
Default

i may be doing something wrong but if i dont do this then the dropdowns dont work.

What do i need to do?
Reply With Quote
  #10  
Old 04-22-2016, 08:31 AM
gmaxey gmaxey is offline Cascading List Word 2010 Windows 7 32bit Cascading List Word 2010 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Something different.

If it doesn't work then yes you are probably doing something wrong.

"If I don't do this" What is it that you aren't doing?
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #11  
Old 04-22-2016, 06:58 PM
macropod's Avatar
macropod macropod is online now Cascading List Word 2010 Windows 7 64bit Cascading List Word 2010 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,367
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

Quote:
Originally Posted by Marvel View Post
Quote:
Originally Posted by gmayor View Post
Quote:
Originally Posted by Marvel View Post
Only one problem i now have is when i restrict the editing i am unable to edit any of the rest of the form.

I need to be able to change other parts of form which do not have these dropdowns in. can anyone help?
Content controls do not require the document to be protected.
i may be doing something wrong but if i dont do this then the dropdowns dont work.

What do i need to do?
That suggests you're using formfields, per an example from Graham's link. If you had used content controls, this wouldn't be an issue.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #12  
Old 05-14-2016, 02:08 AM
Marvel Marvel is offline Cascading List Word 2010 Windows 7 32bit Cascading List Word 2010 Office 2010 32bit
Novice
Cascading List Word 2010
 
Join Date: Apr 2016
Posts: 5
Marvel is on a distinguished road
Default

Thank you all for your help, i managed to get it to work :-)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cascading List Word 2010 Help with cascading dropdown list SaraO Word VBA 43 01-25-2023 04:05 PM
Cascading List Word 2010 Linking WORD Cascading Dropdown Boxes to Excel music_al Word VBA 6 02-15-2016 03:56 PM
Cascading List Word 2010 How to update cascading styles? mmmb Word 3 01-21-2016 07:08 PM
Cascading List Word 2010 Adding a pop-up (cascading) menu to existing commandbar rjrichar40 Word VBA 1 08-28-2014 11:29 AM
Dropdown List in Microsoft Word 2010 bfarquhar Word 2 04-02-2014 07:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:36 PM.


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