View Full Version : Increase the size of a validation list drop-down listbox?

09-24-2006, 01:32 PM
Hey guys,

I was wondering if there was a way to increase the size (or font) of the items in a validation list's listbox? I notice that the size changes with zoom (to give you a better idea of what I mean). I was wondering if there's either a setting in excel or a way I can programmitcally increase the size of this?

The reason I ask is because if the sheet is at a zoom of, let's say, 65%...then the items in the validation listbox is even smaller, and difficult to read.

Please don't ask why I have the view at 65%....it's not my workbook. This is a question a friend came to me with and I didn't have the answer for him. I suggested to just increase the zoom, but I am now curious to know if there is a way to do this without using zoom.

BTW, font size increase does not help either. (I think I was going the wrong route to begin with, but I had to know :))

Thanks in advance! :hi:

09-24-2006, 01:39 PM
Maybe this link might helps.