#1
|
|||
|
|||
Creating a reducing drop down list
Hi I would like to create a drop down list that reduces as selections are made from it so that the selections are placed in an order and each selection is only used once.
For example - Possible selections:- Apple, pear, orange, grape 1. Choice of Apple, pear, orange, grape (Grape selected) 2. Choice of Apple, pear or orange as grape has already been used. (Pear selected) 3. Choice of Apple or orange...........Etc. I have made the drop down list but I am struggling with the content control of the drop down list. Any help is appreciated. |
#2
|
||||
|
||||
With a dropdown list, only one item can be selected at a time, so it's not clear what purpose is served by deleting items once they've been selected. Perhaps you could clarify.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I want the reader of the survey to put the list in order of priority
for example out of four options. 1. Option b 2. Option d 3. option c 4. option a As the person moves down the priority option numbers (1 -4) the drop down list would reduce by the previously selected option so that it is no longer available to select. Thank for taking the time to help. |
#4
|
||||
|
||||
What happens if they change their mind after making a selection? Can they go back and choose a different item?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
All I am trying to achieve is to take the stupidity out of the form to stop me getting option a (for example) for their top 4 priorities.
|
#6
|
||||
|
||||
See attached demo using dropdown content controls. The content controls all have the title 'Question1' and are tagged 'Question1A' - 'Question1D'. The macros in the document's 'ThisDocument' code module drive the process.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
You sir are a star. Thanks very much.
|
#8
|
|||
|
|||
Absolute Dependent dropdowns
Is it possible to create a dropdown that only appears, or becomes live, after a given response to a previous dropdown? For example, if a form filler responds with a yes, then another content control opens with a list of options, but if they respond with a no, the second dropdown doesn't appear or remains inaccessible?
|
#9
|
||||
|
||||
I see you have asked the same question in: https://www.msofficeforums.com/word-...own-lists.html
Kindly don't ask the same question in multiple threads.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to import list from Excel into drop-down list into word | ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
Help with creating an invoice calculator with multiple drop down menus and functions | excerbated123 | Excel | 10 | 02-03-2015 03:07 PM |
Drop Down List Help | ksigcajun | Word | 3 | 05-09-2014 05:35 AM |
Drop down list, Can it be done??? | garethreid | Outlook | 0 | 08-09-2012 06:08 AM |
Dynamically creating new drop down boxes. | dmncs | Word VBA | 1 | 05-06-2012 09:29 PM |