Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
In Excel I need to set up a combo box based on another combo box. | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |