Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default Events for Enter/Exit Textboxes on Userforms

Are there events that trigger when the focus Enters/Exits a Textbox?
If so, what are they?

Thanks,
John

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 644
Default Events for Enter/Exit Textboxes on Userforms

Private Sub TextBox1_Enter()

End Sub

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

End Sub

HTH

Charles

John Fuller wrote:
Are there events that trigger when the focus Enters/Exits a Textbox?
If so, what are they?

Thanks,
John


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default Events for Enter/Exit Textboxes on Userforms

I guess I should have known it would be that simple. *Smacks Self*

Thanks

Die_Another_Day wrote:
Private Sub TextBox1_Enter()

End Sub

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

End Sub

HTH

Charles

John Fuller wrote:
Are there events that trigger when the focus Enters/Exits a Textbox?
If so, what are they?

Thanks,
John


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Button clicks and textbox Exit events Linc Excel Programming 3 December 26th 05 11:23 PM
Can't move from one cell and/or enter any data, or exit wksht... Stuck in One cell Excel Discussion (Misc queries) 2 March 28th 05 06:19 AM
Enter Key behavior with Userforms Lance Excel Programming 3 June 18th 04 09:22 PM
How to enter a Range of TextBoxes? bg18461 Excel Programming 10 May 3rd 04 02:06 AM
On Enter and On Exit events of MSFORMS controls? Haldun Alay[_3_] Excel Programming 1 November 4th 03 01:06 PM


All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"