Combobox selection

[Ian Coates]

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?

 

[Tom Ogilvy]

if you mean using the down arrow, I don't believe so.

 

[Ian Coates]

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.

 

[R-Enemy]

You could use the lost-focus event rather than the change
event. That way nothing would change until they leave the
combobox.

 

[Ian Coates]

Perfect! Thanks very much, and really easy to implement too

Ian