Is there an onEnter event?

Hi,

Suppose I have a form with a text box. Does the textbox have an onEnter
event?

Thanks!

Aaron Fude

[Private] Sub Textbox1_Enter()
'Your code here
End Sub

In VBE, right click on the text box - View Code. The drop down box at the
upper right will have all of the events available for the text box.

--
Damon Longworth

2006 East Coast Excel User Conference
April 19/21st, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
Early Bird Registration Now Open!!
www.ExcelUserConference.com

2006 UK Excel User Conference
Summer, 2006
London, England


<[email protected]> wrote in message
news:[email protected]...
Hi,

Suppose I have a form with a text box. Does the textbox have an onEnter
event?

Thanks!

Aaron Fude

Damon Longworth wrote:
> In VBE, right click on the text box - View Code. The drop down box at the
> upper right will have all of the events available for the text box.
>

That's very useful, thanks!

So which one would I use to react to the user pressing Return?

(That's what I mean by "Enter")

Textbox1_Exit

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

<[email protected]> wrote in message
news:[email protected]...
>
> Damon Longworth wrote:
> > In VBE, right click on the text box - View Code. The drop down box at
the
> > upper right will have all of the events available for the text box.
> >
>
> That's very useful, thanks!
>
> So which one would I use to react to the user pressing Return?
>
> (That's what I mean by "Enter")
>