Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comboboxes
How do you restrict the user to select only values listed in the combobox?
(ie. not be allowed to key in his own values) After that, instead of using the value, as written in the combobox, and assign it to a variable, I'd like to assign the index number instead. (ie. choice number 1, 2, etc) Thanks for the help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comboboxes
First part, change the style property to 2 fmStyleDropDownList
Second, get the ListIndex property value of the combobox. -- HTH Bob Phillips "Darren" wrote in message ... How do you restrict the user to select only values listed in the combobox? (ie. not be allowed to key in his own values) After that, instead of using the value, as written in the combobox, and assign it to a variable, I'd like to assign the index number instead. (ie. choice number 1, 2, etc) Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comboboxes | New Users to Excel | |||
Need help with ComboBoxes. | New Users to Excel | |||
ComboBoxes | Excel Programming | |||
Comboboxes | Excel Programming | |||
Comboboxes | Excel Programming |