Giri
06-10-2011, 10:39 PM
Hi Guys,
I am trying to run a macro from a userform but am having some problems. When I select the macro to be run on the user form and then press OK... nothing happens. ATM, I get an error message saying "Expected Function or Variable" for the WorkoutSelector Macro ... although this macro doesn't not take any inputs. When I delete the Workout Selector line of Code.. there are no error messages but the FindCopy Macro doesn't run (a input box should appear).
PS: Both these macros are in other modules and are Public.
Any help would be greatly appreciated!!
Kind Regards,
Giri
Option Explicit
Private Sub Cancel_Click()
Unload Me
End Sub
Private Sub FindCopy_Click()
End Sub
Private Sub Workout_Click()
End Sub
Private Sub OK_Click()
If FindCopy = True Then
Run FindCopy()
End If
If Workout = True Then
Run WorkoutSelector
End If
End Sub
I am trying to run a macro from a userform but am having some problems. When I select the macro to be run on the user form and then press OK... nothing happens. ATM, I get an error message saying "Expected Function or Variable" for the WorkoutSelector Macro ... although this macro doesn't not take any inputs. When I delete the Workout Selector line of Code.. there are no error messages but the FindCopy Macro doesn't run (a input box should appear).
PS: Both these macros are in other modules and are Public.
Any help would be greatly appreciated!!
Kind Regards,
Giri
Option Explicit
Private Sub Cancel_Click()
Unload Me
End Sub
Private Sub FindCopy_Click()
End Sub
Private Sub Workout_Click()
End Sub
Private Sub OK_Click()
If FindCopy = True Then
Run FindCopy()
End If
If Workout = True Then
Run WorkoutSelector
End If
End Sub