Is there any way to change the font size of the entries in a drop down list generated by data validation?
Is there any way to change the font size of the entries in a drop down list generated by data validation?
Jason
Hi,
Take a look at the attached link
http://www.contextures.com/xlDataVal08.html#Font
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Thanks again,
------------------------------------------------------------------------
Data Validation Font Size and List Length
The font size in a data validation list can't be changed, nor can its default list length, which has a maximum of eight rows.
------------------------------------------------------------------------
I am going to play with the VBA solution but I will not be able to use it.
When you use workbooks within a network and do not have a digital signature, VBA, macros, script etc causes problems . Our ICT department is a bit strict, can't really blame them tho'
Having said that, I really do appreciate the help
No problem,
The code should work ok on a network. Download the file from here
http://www.contextures.com/DataValCombobox.zip
VBA Noob
Thank you just doesn't really say it!!!!
What other miracles can you perform?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks