Hi all, i have noticed that all the cell dropdown lists i have (created by using Data | Validation | Allow | List) are very difficult to read its as though the font is size 8 or 6 or even less, is there a way of displaying the dropdown contents in a larger format?
i have tried changing the font size of the named range and of the cell holding the dropdown but to no avail.
All suggestions welcome!
Regards,
Simon
Re: Data Validation Drop Down List Font Size?
I'm almost certain you can't change the font size but there is a workaround here: http://www.contextures.com/xlDataVal10.html
Re: Data Validation Drop Down List Font Size?
Simon,
You should know better than to cross-post!
Re: Data Validation Drop Down List Font Size?
Stephen thanks for the reply, Bob sorry i was at work and needed the answer before i left!
Regards,
Simon
Re: Data Validation Drop Down List Font Size?
..and you think that excuses you from the rules you agreed to? think again.
Re: Data Validation Drop Down List Font Size?
Quote from StephenR;312700I'm almost certain you can't change the font size but there is a workaround here: http://www.contextures.com/xlDataVal10.html
StephenR,
In regards to 'Data Validation Drop Down List Font Size?' I just starting working with VBA and macros in Excel. I wanted to make the font size bigger for a drop down Validation list. I went to the link you provided and did the following steps, however when it came to the VBA part I wasn't sure where I needed to make changes or add any ranges or cells to make the code apply to my worksheet. The only thing I was sure about doing was changing the name of the combo box to match the name I chose for mine, which is TypeOfBusiness. Could you please tell me where I will need to edit the code so it applies to my worksheet?
I have my Validation drop down list in C2:E2
The cells it's pulling the data from is V2:V6
Thank You,
Alana
Don’t have an account yet? Register yourself now and be a part of our community!
