Drop Down Control Using VBA and NOT Using Data Validation

[snapfade]

Good morning!

I would like to have a Combo Box (drop down) control in the first 50 rows Column A that chooses from a list of 500 options in column L.

I do not want to used data validation because it is too clunky - displays only 8 options, fixed font, no autocomplete, etc. I have read and tried the nicely-designed and well-written option offered by Debra at Ozgrid but that solution is based on Data Validation, which is always present unless one double-clicks in the cell. I am looking for a more elegant solution.

Any suggestions appreciated!

Thanks,
tom

[Winon]

Hello snapfade,

Have you tried implementing a ListBox instead?

[snapfade]

Hi Winon,

I am not sure how this is different from a regular combo box.

The problem, as I see it, is that neither the ListBox nor the ComboBox can be assigned to EACH of the individual cells (50 rows) in column A. Data Validation enables that but again, I do not want to use Data Validation.

Your thoughts?

tom

[snapfade]

Correction. I mistakenly quoted the wrong website in my first post. Debra's website is Contextures.com. Here is the link to the article:

www.contextures.com/xlDataVal10.html#intro

[snapfade]

I found an answer in another thread where I took a different approach. The solution was not VBA after all. It was a sophisticated formula inside Data Validation.

Here is the linkhttps://www.excelforum.com/excel-pro...lp-needed.html

A special thanks to humdingaling!


Cascading Data Validation Help Needed.