My intellisense wanted the index sysntax like

With Me.cmbSource
.AddItem ("Item 1" , 1)
.AddItem ("Item 2" , 2)
.AddItem ("Item 3" , 3)
End With

"CoolCyber" wrote:

also how to add index to the item. My combo box is on the sheet though


"Mike" wrote in message
...
It is on a userform not on the spreadsheet. I am adding the items now at
runtime but how do I prevent a user from typing in a value??


With Me.cmbSource
.AddItem "Item 1"
.AddItem "Item 2"
.AddItem "Item 3"
End With

Thanks
Mike

"Zack Barresse" wrote:

Is this on a worksheet? Why not use Data | Validation | List ?? Much
easier to control there.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board,
as
to benefit others.


"Mike" wrote in message
...
I want a control with a pulldown there will be 3 or 4 values all known
at
design time.

If I use a combobox how do I prevent someone typeing into the box?

How do I add the values to the box?

Thanks