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?






.