[RESOLVED] Exit event

[corolla man]

I have a form with multiple frames. Inside each frame there are textboxes. I want to check the contents of each checkbox as the user exits the box. If I use the exit event for a textbox then for some textboxes (the last box visited in the frame) the exit event is not called. As far as i can tell is that this is because exit is called when you change focus to objects on the same frame, but because focus is going to another frame exit is not being called (it gets called when I reenter the frame and select another textbox in the same frame). How can I get my exit event to be called?
I have attached a screen shot of one of my frames.

[Bruce Fox]

Hi corolla man, Welcome to the Forum

In addition to the TextBox Exit validations, you could supliment by using the Frames_Exit event and check the associated TextBoxes.

Obviously there is doubling up of the validation (as each one is checked as you pass through, but would detect the focus to a new Frame)

To validate only those TextBox's with in a particular frame, place this in the MAIN frames Exit:

Private Sub Frame1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim ctl As Control
 
    For Each ctl In Frame1.Controls
        If TypeOf ctl Is MSForms.TextBox Then
            'Validate code here
            MsgBox ctl.Name
        End If
    Next
 
End Sub

[corolla man]

Thanks for your reply bruce
I ended up replacing the frames with images of a rectange which looks like a frame. This way I didnt need to double up.

Thanks again
Steve