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

maybe as part of your coding simply add in

textbox1.set focus

so even if the focus wanders to the command button, it's instantly
redirected back to the textbox.
just an idea.
:)
susan



"Tetsuya Oguma" wrote in message

...



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- Hide quoted text -


- Show quoted text -