I'd like to be able to change the formatting (color, size, font) of a Combo Box in Excel for Mac but cannot find a solution or come up with one on my own. Since I am using a Mac I cannot do it as I would have done on a Windows computer.

I'm using this code to set the size of the Combo Box:
Sub ComboBox_Create()

Dim Cell As Range
Dim sht As Worksheet

Set sht = ThisWorkbook.Worksheets("Sheet1")

'Create a ComboBox according to values (left, top, width, height)
sht.DropDowns.Add(80, 10, 150, 20).Name = "Combo Box 1"


I've tried things like the ones below without success.

ActiveSheet.Shapes("Combo Box 1").TextFrame.Characters.Font.ColorIndex = 3
Shapes("Combo Box 1").Fill.ForeColor.SchemeColor = 47
Shapes("Combo Box 1").Font.Color = 0
Range("B4:D5").Interior.ColorIndex = 5
Shapes("Combo Box 1").Interior.ColorIndex = 5
sht.DropDowns("Combo Box1").Object.BackColor = RGB(255, 0, 0)