This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am creating a form. May I know is there anyway for me to create a drop-down box to rank importance? For example, the respondent is to rank the areas in their lives below from the most important to least important. The function that I am asking for now is, to have drop-down boxes for all areas below. In addition, as the respondent select any of the area, let's say - 'Friends' as the first selection, the rest of the selections will only show - '2,3,4,5,6', and after another selection, the choices will become 3-6, 4-6, 5-6, and lastly, '6' only.
| Lifestyle | 3 |
|---|---|
| Family | 6 |
| Vacation | 4 |
| Hobby | 5 |
| Career | 2 |
| Friends | 1 |
After much research, I've only discovered ways to create dependent drop-down boxes for one relationship between two variables only using macros. Therefore, should there be any other ways or macros that can help, appreciate much if you can share with me.
A family of Microsoft word processing software products for creating web, email, and print documents.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Thank you Jim. It is very useful indeed. Do appreciate your help.
May I ask, do you, by any chance, have it in Microsoft Word as well?
Alexis
The Combo Box Demo workbook is available again at...
'---
Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)
(free & commercial excel add-ins & workbooks)
Hi Jim,
I am so sorry that I only saw your replies today. Truly appreciate your help, but do you mind sharing it again? I will check this post daily now for your reply. Am so sorry for the inconvenience caused.
Alexis
No downloads of the 'Combo Boxes Demo' since I placed it on the jumpshare website, so I have removed it.
'---
Jim Cone
I've just posted an .xls workbook as 'Combo Boxes Demo' to the jumpshare website...
Go to...
It has a userform with 8 dropdown boxes with mutually exclusive choices.
Maybe you can use some of it.
'---
Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)
(free & commercial excel add-ins & workbooks)