Checking multiple textboxes on a userform

[Mhat]

Hi all,

I have 12 textboxes on a userform. If there is data in any one of the textboxes I want to display a message box informing the user that the data has not been saved. I was thinking about using an If/Then statement. Do I have to list every text box on the form to have it checked for data or is there an easier way.

Regards,

Mike

 

[BrianB]

Something like this :-

Private Sub CommandButton1_Click()
    Dim ctl As MSForms.Control
    For Each ctl In Me.Controls
        If TypeName(ctl) = "TextBox" Then
            MsgBox (ctl.Name & vbCr & ctl.Value)
        End If
    Next ctl
End Sub