Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I want the users can be able to select only from the values in combobox index. Typing would not be allowed in combobox. I comboboxes can be used as textboxes. But i do not want it... Match required function does not do what i want, still users are enabled to type a text but they are warned after if the text is not same as one of the value in index. I want them they would not be able to type anything, just can select... (well, i do not want to be any curser in typing place :)) Thanks... |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try changing the .Style of the combobox to fmStyleDropDownList.
SupperDuck wrote: Hello, I want the users can be able to select only from the values in combobox index. Typing would not be allowed in combobox. I comboboxes can be used as textboxes. But i do not want it... Match required function does not do what i want, still users are enabled to type a text but they are warned after if the text is not same as one of the value in index. I want them they would not be able to type anything, just can select... (well, i do not want to be any curser in typing place :)) Thanks... -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks! It works...
"Dave Peterson" wrote: Try changing the .Style of the combobox to fmStyleDropDownList. SupperDuck wrote: Hello, I want the users can be able to select only from the values in combobox index. Typing would not be allowed in combobox. I comboboxes can be used as textboxes. But i do not want it... Match required function does not do what i want, still users are enabled to type a text but they are warned after if the text is not same as one of the value in index. I want them they would not be able to type anything, just can select... (well, i do not want to be any curser in typing place :)) Thanks... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to update a ComboBox when selecting a sheet | Excel Worksheet Functions | |||
Selecting a worksheet from a combobox | Excel Programming | |||
Event when selecting an item in a combobox? | Excel Programming | |||
ComboBox index | Excel Programming | |||
Selecting a worksheet with a ComboBox | Excel Programming |