ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Comboboxes (https://www.excelbanter.com/excel-programming/321429-comboboxes.html)

Darren

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

Bob Phillips[_7_]

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





All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com