![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
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?
|
#3
|
||||
|
||||
![]()
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] |
#4
|
|||
|
|||
![]()
I had forgotten about this tips page:
http://gregmaxey.com/word_tip_pages/...down_list.html |
#5
|
|||
|
|||
![]()
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 |
#6
|
|||
|
|||
![]()
Everything you need should be available in the links provided.
|
#7
|
|||
|
|||
![]()
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 |
#8
|
||||
|
||||
![]()
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 |
#9
|
|||
|
|||
![]()
i may be doing something wrong but if i dont do this then the dropdowns dont work.
What do i need to do? |
#10
|
|||
|
|||
![]()
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? |
#11
|
||||
|
||||
![]() Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#12
|
|||
|
|||
![]()
Thank you all for your help, i managed to get it to work :-)
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
SaraO | Word VBA | 43 | 01-25-2023 04:05 PM |
![]() |
music_al | Word VBA | 6 | 02-15-2016 03:56 PM |
![]() |
mmmb | Word | 3 | 01-21-2016 07:08 PM |
![]() |
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 |