Thread: Comboboxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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