Font size of list

[martynduerden]

Is it possible to increase the font size of a drop down list?

Cheers

Martyn

[romperstomper]

It depends what kind of dropdown. If it's data validation or a Forms control, then no. If it's a combo from the Control Toolbox, then yes.

[buran]

If it is a ComboBox Control on User Form - yes you can. Same for the ListBox Control.

You can do it from the Properties -> Font or just put this code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

in the UserForm_Initialize. Change it according to your needs.

If it is Control on the worksheet - you can cahnge the font size too.

I'm not sure in the case it is data validation.