| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox selection
Is there a way to limit selections in a combobox to using the drop-down
arrow then clicking on a selection, rather than being able to select the combobox and cycle through the options? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combobox selection
if you mean using the down arrow, I don't believe so.
-- Regards, Tom Ogilvy "Ian Coates" wrote in message ... Is there a way to limit selections in a combobox to using the drop-down arrow then clicking on a selection, rather than being able to select the combobox and cycle through the options? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combobox selection
Shame. I wanted to avoid the changes to the sheet unnecessarily when a user
cycles through the options. Oh, well. It'll just have to take longer to update on the slower PCs. "Tom Ogilvy" wrote in message ... if you mean using the down arrow, I don't believe so. -- Regards, Tom Ogilvy "Ian Coates" wrote in message ... Is there a way to limit selections in a combobox to using the drop-down arrow then clicking on a selection, rather than being able to select the combobox and cycle through the options? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combobox selection
You could use the lost-focus event rather than the change
event. That way nothing would change until they leave the combobox. -----Original Message----- Shame. I wanted to avoid the changes to the sheet unnecessarily when a user cycles through the options. Oh, well. It'll just have to take longer to update on the slower PCs. "Tom Ogilvy" wrote in message ... if you mean using the down arrow, I don't believe so. -- Regards, Tom Ogilvy "Ian Coates" wrote in message ... Is there a way to limit selections in a combobox to using the drop-down arrow then clicking on a selection, rather than being able to select the combobox and cycle through the options? . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combobox selection
Perfect! Thanks very much, and really easy to implement too :-)
Ian "R-Enemy" wrote in message ... You could use the lost-focus event rather than the change event. That way nothing would change until they leave the combobox. -----Original Message----- Shame. I wanted to avoid the changes to the sheet unnecessarily when a user cycles through the options. Oh, well. It'll just have to take longer to update on the slower PCs. "Tom Ogilvy" wrote in message ... if you mean using the down arrow, I don't believe so. -- Regards, Tom Ogilvy "Ian Coates" wrote in message ... Is there a way to limit selections in a combobox to using the drop-down arrow then clicking on a selection, rather than being able to select the combobox and cycle through the options? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ComboBox Selection | Excel Discussion (Misc queries) | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| How do i populate a text box according to selection in combobox? | Excel Worksheet Functions | |||
| Formatting a ComboBox selection | Excel Programming | |||
| Combobox not writing value if next selection is same | Excel Programming | |||
Linear Mode
