View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How can I activate a combobox by keyboard strokes ?

What kind of comobox

Data validation (List option)
Dropdown box from the forms toolbar
Combobox from the control toolbox toolbar

--
Regards,
Tom Ogilvy

Oscar wrote in message
. nl...
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