Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 989
Default textbox's exit event

Hello.

I have a textbox where a fiscal month name is entered. Based upon that, two
labels are populated. All three of these controls are within a frame control.

Originally, I had a second textbox in the same frame, that could take input.
But then I decided I didn't need/want it, and changed it to a label.

Now, when there is no other tabstop control in the same frame, I've
discovered that the first textbox's exit event doesn't fire.

I proved that by building a very simple form. I started with a blank form,
inserted a frame with one textbox and one label in the frame, and one textbox
outside of the frame.

With that, for the textbox in the frame, the exit event does not fire when I
tab to the second textbox outside of the frame. The first textbox's exit
event does fire when I use the X in the upper right to exit the form.

Why would a textbox's exit event firing be limited like that? Shouldn't it
fire no matter what when the textbox is exited?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 989
Default textbox's exit event

I've accomplished what I need using the AfterUpdate event.

I still don't understand why the timing of the firing of the Exit event for
a textbox would be dependant upon other controls within the same frame,
though.



"mark" wrote:

Hello.

I have a textbox where a fiscal month name is entered. Based upon that, two
labels are populated. All three of these controls are within a frame control.

Originally, I had a second textbox in the same frame, that could take input.
But then I decided I didn't need/want it, and changed it to a label.

Now, when there is no other tabstop control in the same frame, I've
discovered that the first textbox's exit event doesn't fire.

I proved that by building a very simple form. I started with a blank form,
inserted a frame with one textbox and one label in the frame, and one textbox
outside of the frame.

With that, for the textbox in the frame, the exit event does not fire when I
tab to the second textbox outside of the frame. The first textbox's exit
event does fire when I use the X in the upper right to exit the form.

Why would a textbox's exit event firing be limited like that? Shouldn't it
fire no matter what when the textbox is exited?

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
Exit Event Patrick Simonds Excel Programming 2 August 27th 06 09:25 PM
exit event John Pierce Excel Programming 3 February 2nd 06 02:00 AM
Need some help with Exit Event Matt[_31_] Excel Programming 4 April 1st 05 12:22 AM
Form Exit Event JT[_2_] Excel Programming 1 September 17th 04 02:29 AM
Exit Event Michael J. Malinsky Excel Programming 1 February 27th 04 07:40 PM


All times are GMT +1. The time now is 09:39 AM.

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"