combo box txt size

ben2001 · #1 (**permalink**) 02-04-04, 17:43

how do you change the size of the text in a combo box?
Ben

Smitty · #2 (**permalink**) 02-04-04, 19:35

If it's a Forms ComboBox, you don't. Increasing screen zoom is about it.

If it's a Control Toolbox ComboBox, select Properties-->Font and adjust from there.

Hope that helps,

Smitty

ben2001 · #3 (**permalink**) 02-05-04, 07:24

Control Toolbox ComboBox is what i need. but im not sure how the information is inputted into the combo box ? ? ? please help!
Ben

Smitty · #4 (**permalink**) 02-05-04, 12:11

Are you using a UserForm or are your controls placed directly on the spreadsheet?

Either way, ActiveX controls (those created from the Control Toolbox) have their own VBA code associated with them. In Design mode, double click the control and VBA will open with:

Private Sub ComboBox1_Change()

End Sub

From there, look at the AddItem Method for populating the combo Box. I.E.

Code:

Private Sub ComboBox1_Click()
    With ComboBox1
        .AddItem "Office 1"
        .AddItem "Office 2"
        .AddItem "Office 3"
        .AddItem "Office 4"
        .AddItem "Office 5"
    End With
End Sub

Private Sub ComboBox1_Change()
    '  Return the selection to the worksheet
    Range("B1") = ComboBox1
End Sub

Hope that helps,

Smitty