How to create drop-down list for importance ranking?

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. 



 

Question Info


Last updated October 15, 2019 Views 796 Applies to:

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)


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

No downloads of the 'Combo Boxes Demo' since I placed it on the jumpshare website, so I have removed it.
'---
Jim Cone

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.


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)

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.


No, I do not have a Combo Box Demo available in MS Word.

The only programming I have done involving Word is in my free 'Thesaurus for Excel' program.
It uses Word to create the synonym / antonym lists.
'---
Jim Cone

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Alright. Noted with many thanks Jim.

Take care and all the best.

Alexis

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.