Hello, I started using VBA recently and I have a question. I am using the case study shown below in a UserForm.
Through a different subroutine named ActivateGAS (shown below) and called after the above select case option, i want to perform an If...else If case structure ( I think that is the most appropriate). Maybe its a stupid question, but I don't know how to find out whether a subroutine is active or not.
The IsActivated command its just something i made up my mind to show what I'm looking for.
Code:
Case 0: Call ActivateHDB
Case 1: Call ActivateHDT
Case 2: Call ActivateLD4C
Case 3: Call ActivateLD4T
Case 4: Call ActivateM4
Case 5: Call ActivateLD2
Code:
Sub ActivateGAS()
With wb1
Selection.Rows(5).Select
End With
With wb2
If IsActivated.ActivateLD4C Then
Selection.Rows("1:7").Select
ElseIf IsActivated.ActivateLD4T Then
Selection.Rows("1:7").Select
Else
Selection.Rows("1:4").Select
End If
End With
End Sub