There are two types of Combo boxes - the first comes from the Forms menu (View/Toolbars/Forms) and the second comes from the View/Toolbars/Toolbox.
You cannot change the font size for combo boxes from the Forms menu (this question has been posed many times on other Excel boards - nobody has ever offered a solution, VBA or otherwise). However, you can change the font size (including font color, font type e.g Arial and background color of the Combo box) for combo boxes from the View/Toolbars/Toolbox. You may wish to look at the Toolbox method.
If you get stuck, pose your questions in a new thread.
If so click on view then Toolbars then VisualBasic.
When the toolbar appears press Design Mode icon (shaped like a triangle and penicl). Then right click on the ComboBox and select properties. The properties window should open and your combo box should be the selected item.
Go down the list to Font. Click in the Font area and a small button with 3 dots should appear, click on this to open the Font Dialog Box. Use the Font dialog box as normal to select the size of the text.
This should now work for you. Close the properties box and re-click Design Mode to exit from it.
Try that and let us nkow if it works or if still having problems.
I see the problem, I have indeed created the Combo Boxes from the the Forms menu and now realise there properties cannot be changed.
I have found the Combo Boxes in Control Toolbox.
I have some more questions, please bear with me I had no idea I would have to start playing around with VB in order to design an Excel spreadsheet for my business!
How can you change the number of drop down lines, how do you enter text on each drop down line and will each line return an ascending numerical value when selected in the same way as the Combo Boxes in the Forms menu?
Just in case you need it here's a quick way to load data from a Excel spreadsheet into your dropdown box. Assuming your data is in column A starting at row 1.This assumes 40 items to be listed but you could code to check how many rows of data you need and set a variable for it.
Dim i as Integer
Dim s() as String
For i = 1 to 40
s(i - 1) = .Cells(i, 1).Value
.ComboBox1.AddItem .Cells(i, 1).Value, i -1