View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default How can I set focus back or remained on Textbox?

Hi Tetsuya,

Change these Textbox properties

EnterKeyBehavior True
MultiLine True

Now hitting Enter will create a new line, not sure if that's what you want.

Regards,
Peter T

"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