Drop down list
 

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?
--
tia

Jock

Drop down list
 

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

NickHK

"Jock" wrote in message
...
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?
--
tia

Jock

Drop down list
 

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


---
Regards,
Norman


"Jock" wrote in message
...
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?
--
tia

Jock

Drop down list
 

Thanks guys
--
tia

Jock


"Norman Jones" wrote:

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


---
Regards,
Norman


"Jock" wrote in message
...
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?
--
tia

Jock