Forum Discussion
Font size in a drop down list
I don't know if you are still looking for a solution to your problem, but this might be helpful. The only way I know to increase the size of text in a dropdown list box is to use a combobox. I used this solution for a project of mine and it worked for me. I got the instructions from a website, Contextures. This is the URL: https://www.contextures.com/xldataval11.html#Create
It uses an ActiveX Control Combo Box, The nice thing about this solution is that you can change the font type, text size, and number of rows.
If you watch the video it explains her whole process. It involves a lot of VBA code (which you can download). If you just need a few dropdown boxes, you can just add some comboboxes and link a list of items. I tried it on a sample sheet and it worked as a simple dropdown list.
I hope this helps.
Henry