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? |
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? |
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? |
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? . |
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? . |
All times are GMT +1. The time now is 09:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com