Combobox selection

  • Thread starter Thread starter Ian Coates
  • Start date Start date
I

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?
 
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.
 
You could use the lost-focus event rather than the change
event. That way nothing would change until they leave the
combobox.
 
Back
Top