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

Is there an onEnter event?
 

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

Is there an onEnter event?
 

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


wrote in message
oups.com...
Hi,

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

Thanks!

Aaron Fude

Is there an onEnter event?
 

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")

Is there an onEnter event?
 

Textbox1_Exit

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

wrote in message
oups.com...

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")