Validate textbox fields in VBA Form before Submit

Guessed · #1 03-18-2019, 06:51 PM

You haven't provided any code so you will need to adapt this to your purposes

Code:

Private Sub btnOK_Click()
  Dim i As Integer, aCtl As Control
  For i = 1 To 8
    With Me.Controls("TextBox" & i)
      If .Value = "" Then
        MsgBox "Nothing in this one"
        .SetFocus
        Exit Sub
      Else
        MsgBox .Name & vbCr & .Value
      End If
    End With
  Next i
End Sub

ScottyBee · #2 03-19-2019, 05:43 PM

Thanks Guess, you helped me make some major progress. I did have one question though. What is the purpose of declaringaCtl as a Control since it is not used in any of the code? Thanks

Dim i As Integer, aCtl As Control

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook Custom form - submit and approve buttons	R Mohan	Outlook	0	06-18-2018 12:57 PM
Infopath PDF attached to Form not showing in Email Submit	CliffEstel	Misc	0	09-20-2016 11:04 AM
Submit form	deb	Word	0	06-20-2015 07:01 AM
Macro to keep formatted form fields after mail merge or replace text with formatted form fields	jer85	Word VBA	2	04-05-2015 10:00 PM
VBA Code for a SUBMIT button in a Word form	BlueMax	Word VBA	3	08-07-2013 06:26 AM