CodesiriuS
12-19-2016, 04:41 PM
Hello - I have a userform with two command buttons and three check boxes -
The first command button gets a file and drops it in a textbox -
Then I have three Check boxes (all formatting related)
My Question is surrounding my command button 2 "Process File" I was hoping the user would select this button and then based on whether the checkbox is checked will run the macros associated with the check boxes selected - I get a error at the application. Run
Does anybody know why this isn't working?
Private Sub CommandButton2_Click()
If CheckBox1.Value = True Then
Application.Run
Else
End If
CheckBox1.Value = False
If CheckBox2.Value = True Then
Application.Run
Else
End If
CheckBox1.Value = False
The first command button gets a file and drops it in a textbox -
Then I have three Check boxes (all formatting related)
My Question is surrounding my command button 2 "Process File" I was hoping the user would select this button and then based on whether the checkbox is checked will run the macros associated with the check boxes selected - I get a error at the application. Run
Does anybody know why this isn't working?
Private Sub CommandButton2_Click()
If CheckBox1.Value = True Then
Application.Run
Else
End If
CheckBox1.Value = False
If CheckBox2.Value = True Then
Application.Run
Else
End If
CheckBox1.Value = False