excel combo box
 

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

excel combo box
 

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

excel combo box
 

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

excel combo box
 

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

excel combo box
 

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