Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there an onEnter event?
[Private] Sub Textbox1_Enter()
'Your code here End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to trap delete row event and hide column event? | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
Event Procedures: Event on Worksheet to fire Event on another Worksheet | Excel Programming | |||
change event/after update event?? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |