malik641
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:
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: