I would like the combo box to have a static set of values, but I don't
know how to do it. I have tried to use rowsource, but the three cells
I want are not together (D9,J9,D52), is there a way just to type in
the values I want on the list? Any help would be greatly appreciated.
Thank you.

Hi Mastermind,

Perhaps, try something like:

'=============
Private Sub UserForm_Initialize()
With Me.ComboBox1
.AddItem "Value 1"
.AddItem "Value 2"
.AddItem "Value 3"
.ListIndex = 0
End With
End Sub
'<<=============


---
Regards,
Norman


"mastermind" wrote in message
oups.com...
I would like the combo box to have a static set of values, but I don't
know how to do it. I have tried to use rowsource, but the three cells
I want are not together (D9,J9,D52), is there a way just to type in
the values I want on the list? Any help would be greatly appreciated.
Thank you.