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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>