View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tetsuya Oguma Tetsuya Oguma is offline
external usenet poster
 
Posts: 19
Default How can I set focus back or remained on Textbox?

Hi all,

I use the following Events associated with Textbox
1. BeforeDropOrPaste (for OLE drag and drop)
2. Keydown (for capturing key stroke)

by Taborder, the next control that gets focused is Commandbutton.

Simply put, I want focus to remain in the Textbox control when user presses
Enter key.

At the moment, I can clear the entry in the Textbox but no matter how I code
it focus shifts to the Commandbutton...

Thanks in advance.
Tetsuya Oguma