(Solved) – VBA Help: Loop Sub function


I need to loop the below function however I can’t seem to figure it out. The goal:

  1. fldUserLogonID is no longer 1 cell (it can be up to 500 cells) – dependent on whether another cell has a value or not

Would anyone know how I can approach this?
I have tried Setting a new variable to have a range & changing the fldUserLogonID “field” into a Range however no luck.

Code below:

Private Sub CommandButton1_Click()
    Dim user As String
    Dim fldUserLogonID As String

    If (ActiveSheet.range("fldUserLogonID").Value = "") Then
        MsgBox "Please enter the User's Lan ID and then click on Populate Button"     
        Call Module5.username1
        Call Module5.FindUser
    End If
    'Call Sheet1.ComboBox16_Click

    Application.EnableEvents = True
    'Application.EnableEvents = False

    'If ActiveSheet.Range("User_ID").Value = "" Then
End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *