Thread: GotFocus event
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dale Fye Dale Fye is offline
external usenet poster
 
Posts: 169
Default GotFocus event

I do most of my work in Access, and would like to know if there is a GotFocus
event for Excel combo boxes. I like to setup my forms to limit the users
need to use the mouse, so I generally set my combo boxes to dropdown
automatically in the GotFocus event of a control.

I could not find this event associated with my controls (Excel 2003), so I'm
trying to use the Enter event instead. This works if I click in the control,
or if I am tabbing from a textbox into the combo box, but if I tab out of a
control that is currently dropped down, then the next combo box doesn't drop
down. If I select the item in a combo, then tab into the next combo it works
properly.

Any ideas?
--
Email address is not valid.
Please reply to newsgroup only.