font too small in list box

Hello All

Hope some one can help me .
I have created a list box drop down in excel 2013 with data validation.
Was wondering if one can make the font bigger of the list box currently it is very small, and changing the font of the data i base the list box on to be bigger dont change the size of the letters in the list box.

Hey there,
As per my knowledge you cant change size or font of list box.

However, you can add a "Combo Box" from the Developers Tab>> Insert>> Combo Box
Now you can Right Click on it and click on properties.
Here you can link it to a cell from "Linked Cell"
You can also edit the font, size , color and anything.
Check attached.

Excel doesn't offer an option to size text within a dropdown list in data validation. If you change the zoom level for the worksheet, the dropdown size will also increase. You could zoom up then make all the worksheet fonts smaller, but that's a bit of a hack.

Another option is to use a ComboBox control.

Edit: I see sourabhg98 has already covered this ground.

Captain Flash, your question is a new question that goes far beyond the original question. Therefore please start a new thread with your question.

As a new member, please take the time to review our rules. There aren't many, and they are all important. Rule #2 is that members should not hijack someone else's thread by asking a new question. Thanks.