Add Combo Box Drop Down List to Excel Worksheet

[jamesejordaniii]

thank you so much!!



[Karin16121968]

I find out I just made I little mistake. Thanks anyway for this great video

[Karin16121968]

I have a problem to put my ListFill Range it doesn´t take the name I gave to my range! Can you hep me to solve this problem Thanks in advance for your support!

[pastrrrmike]

In the "ListFillRange" inside the combo box properties. How does one reference a range (eg. lista - as you have in the example above) if it was in a different worksheet in the workbook (eg. you have 1 page/sheet for data entry and processing, and a separate page/sheet where you have all of your reference information)?

Any help on that would be greatly appreciated!

[anandvshah1]

This is well explained. Thanks for sharing.

[yuchubhu]

You always amaze me by how you bring out these little known and yet profound functions of excel. If I had to pay to subscribe to your videos, I would seriously consider it!! :-) . Thanks for all you are doing for the excel enthusiasts..

[contextures]

@yuchubhu Thanks! I'm glad you find the Excel videos so helpful.