Results 1 to 8 of 8

Thread: Find Form Controls with Value not set

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    VBAX Newbie
    Joined
    Jun 2021
    Posts
    4
    Location
    Quote Originally Posted by snb View Post
    Why don't you post a sample file to illustrate your questions ?

    sorry u re right

    Private Sub MultiPage1_Change()
    Dim i As Integer 
    dim contr as control
    
        For Each Control In UserForm1.Controls
               If TypeName(contr) = "ComboBox" Then
                      For i = 1 To 2
                          If Controls("ComboBox" & i).Value = "" Then
                                  MsgBox " you have incomplete answers"
                          End If
                      Next i
                 End If
              Next
    End Sub
    Last edited by SamT; 06-02-2021 at 07:13 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •