View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Check for Enter key and change focus?

The keyup and keydown events are triggered by a Return.

--
Regards,
Tom Ogilvy

"NooK " wrote in message
...
Thanks, the SetFocus worked out nicelly, but the Exit event is not what
I am looking for because if the user for example clicks anywhere else
in the form (Say the listbox) whatever is in the textbox will
automatically be aded to it and that's not right, Only if the user
presses Enter is the stuff to be added.

Isn't there anyway at All?

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/