You would modify the SelectionChange event to perform both the action of
hiding the combobox if it is appropriate or displaying the combobox if that
is appropriate.

--
Regards,
Tom Ogilvy

"Rene H" wrote in message
...
Hello,

We have to provide a drop down list in a worksheet and have implemented
the
feature as described in http://www.contextures.com/xlDataVal11.html. Works
ok
so far and fulfils the requirement of searching a matching entry as you
type.

As we have very demanding people in the company they don't like that they
have to double-click on the cell to activate the combo box.

How can we show the combo box as soon as they enter the cell?
Any ideas?

Regards
Rene