Data Validation - Using a Combo box to help with font size

[LukusCarnilious]

Hi,

I've seen a lot threads on the internet which say use a combo box to help with font size if the text is too small in a normal data validation list. They all seem to point to the same thread on contextures.com but that doesn't explain how to set up a combo box for 2010 version of excel.

I have cells Q:26:Q150 set up with a data validation list which changes based on the selection in E26:E150.

So for the data validation in the Q column I have used =INDIRECT($E26) which the goes through to 150.

The data validation for column E uses a Define Name of the list I need on another sheet.

So to explain if E26 is selected as "Circular" the drop down list in Q26 will show a list of 34 items.
If E26 is changed to "Rectangular" the drop down list in Q26 will show a list of 31 items.

What I would like to do is have a combo box appear when you click on any of the Q26:Q150 cells but make sure the combo box list changes with the selection in E26:E150.

I know its going to require some kind of code but have no idea where to start.

Thanks

Luke

 

[RickXL]

Hi,

Th details are on the Contextures site: http://www.contextures.com/xlDataVal10.html

The code provides a range with the data in and requires a double-click to move the combobox to the cell being populated.