Forum Discussion
Thomas_Micklem
Jun 13, 2021Copper Contributor
Resize text in drop down list?
I am busy setting up a spreadsheet in which I use drop down lists to select the text to put in certain cells but when I click on the drop down list the text in the list is very small and I cannot rea...
- Jun 13, 2021
Afraid drop-down box in data validation is not configurable.
NikolinoDE
Jun 13, 2021Gold Contributor
or change the zoom factor with VBA
Actually it is not possible as Mr. Baklan has already written to you.
But with VBA you can workarond it.
You could also do it with a combo box as a workaround.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Berni002
Dec 23, 2021Copper Contributor
I am working with VBA code to zoom into the drop down list, as it is too small to read. However, do not get the VBA code for this working with the VBA code for multiple entry in the drop down list. Have you had this experiance before and any hint how to solve it?
Thanks a lot