Hi Oscar,

It worked for me on both data validation and a control toolbox combo.

Maybe as Tom suggests you can tell which combo you are using.

Oscar wrote:

Yes,
that didn't work.



"Andy Pope" schreef in bericht
...

Hi Oscar,

Have you tried ALT + down arrow?

Oscar wrote:


I want to pull down a combo box that is within an Excel sheet and select

an

item within the list by the keyboard instead of using the mouse which

will

satisfy the user in case the user doesn't want to switch between

keyboard

and mouse all the time. How can I activate the combobox events (such as
dropdown and select an item by pressing return key) automatically from

the

keyboard strokes or do I have to write my own procedures ?

Oscar



--

Cheers
Andy

http://www.andypope.info





--

Cheers
Andy

http://www.andypope.info