After adding your combobox to the sheet you need to access it's prperties from the toolbox. You must be in Design View - the setsquare icon.
The Font property allows you to change the font type & clicking the small button to the right gives you more options including size.
The ListFillRange property allows you to define the source, type in the name or address of your range.
To add the selection to a specific cell, as shg says, use the Click event. Click <View Code> & add this
Option Explicit
Private Sub ComboBox1_Change()
'write to A1 of active sheet
Cells(1, 1).Value = Me.ComboBox1.Value
End Sub
Bookmarks