Excel: enlarging a Drop-down/Validation

[Elisha]

I have a Drop-down list I created in a cell in Excel in Data -> Validation. The problem is that it is so small! How do I enlarge it? Is it even possible?

The Cell is currently Arial 14 and Bold, which is great, but the drop-down ends up being around size 8 font! What gives?!?

[Bama Gambler]

Prolly not the solution you were hoping for but: View menu, Zoom.

[Old Timer]

I believe the size of the data validation text is driven by one of the windows font settings for some other characteristic such as button text or something else.

If the font needs to be bigger and you don't want to zoom, then you'll need to change to a combo box from the control toolbox.

[Elisha]

Prolly not the solution you were hoping for but: View menu, Zoom.
Umm, no.

OldTimer,
Anything more specific? Where would I change this? Thanks.

[Old Timer]

If it is just for you, I think you'll have to change each font option in Control Panel/Display/Appearance until you get the one that controls the data validation font size. If this works, you have to decide if you can live with the change to whatever else changes.

If you need to do this for someone else and you don't want to change their settings permanently, you need to make an API call and make sure you turn it back once done. You would be better off in either case with a combo box IMO.

[GatesIsAntichrist]

I'm sorry I have nothing to add to the font dilemma. However at first I though you were saying that the dropdown itself was too small (i.e. short/narrow) and it reminded me of this. Anyway, I recommend that anyone take advantage of this link, because the "Name box" (Excel's upper left corner dropdown box) is indeed too small.

You can widen the Excel "name box" (Name box is the one that sometimes says "Print_Area") as indicated in
http://www.cpearson.com/excel/NameBox.htm
(I personally used an EventClass class module for the code, instead of the standard module Chip suggests.)

Originally I was going to suggest that essentially this is an API call to a found window ... so if you know how to programatically "Find" the window (i.e. object, i.e. dropdown) of concern - this method oughtta get 'er duuun. But now that I think about it, your dropdown's width is controlled by the cell's column's width anyway. Duh! Doh!