Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
[Private] Sub Textbox1_Enter()
'Your code here End Sub |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |