Drop down list

[Guest]

I would like, if possible, to programme Excel to show an entire drop down
list, rather than some of it and a scroll bar to find other options further
down in the list.
Also, can the font size (and perhaps colour) used to show the list be
altered to a larger one?

 

[NickHK]

Jock,
Check out the .ListRows (maybe set = .ListCount), .Font and .ForeColour
properties of the combo box.

NickHK

 

[Norman Jones]

Hi Jock,

It is not possible to change either the data validation
font size or the list length.

However. for a workaround, see Debra Dalgleish at:

Data Validation Font Size and List Length
http://www.contextures.com/xlDataVal08.html#Font

 

[Guest]

Thanks guys
--
tia

Jock

Hi Jock,

It is not possible to change either the data validation
font size or the list length.

However. for a workaround, see Debra Dalgleish at:

Data Validation Font Size and List Length
http://www.contextures.com/xlDataVal08.html#Font