Decide which macro to run based on cell value

[theojanissen]

Within a macro 'decision' I want to call depending on the value of the cell value in B75 that either can be ''text1'' or ''test2" the corresponding macro 1 or macro 2. I tried several ways but I simply cannot get it to work. Any help would be appriciated.

Kind regards, Theo

 

[JLGWhiz]

Sub Decision()
'code stuff here
 If Range("B75").Value = "text1" Then
  macro1
 ElseIf Range("B75").value = "test2" Then
  macro2
 End If
'Other code if needed
End Sub

 

[theojanissen]

Thanks, works perfect.
Regards from the Netherlands

 

[JLGWhiz]

Happy to help,
Regards, JLG