text box in frames in user forms

[VBAmalta89]

I have a user form which contains a frame. Within this frame tehre are a number of text boxes where the user is asked to enter numerical information.

I would like to create a data validation so that when the user clicks teh done button on the user form, the procedure is halted and a message prompted if one of the text boxes is left blank.

How can i code this?

 

[northwolves]

Try it:

Private Sub CommandButton1_Click()
    Dim ctl As Control
    For Each ctl In Frame1.Controls
        If ctl.Value = "" Then
            MsgBox ctl.Name & " not filled!"
            ctl.SetFocus
            Exit For
        End If
    Next
End Sub

Regards
Northwolves