I need to loop the below function however I can’t seem to figure it out. The goal:
fldUserLogonIDis 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.
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" Else 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