Increasing the size of a drop down list

[Richard]

Using cell validation I have selected certain cells where
data can only be selected from a list.

When there is a long list the drop down window list seems
very small which makes searching for the correct
information a bit difficult.

Is there any way I can increase the size of the drop down
list 'window' therefore increasing the amount of visible
data at any one time or is the size of the drop down list
fixed?

I would be very grateful of some feedback,

Many thanks,

Richard

 

[Ron de Bruin]

Hi Richard

The font size in the list can't be changed.
You can make the font appear larger if you increase the zoom setting
(manually, or through code).

See Debra's site for more information about Data-Validation
http://www.contextures.com/xlDataVal01.html