If cell meets condition then run macro

[Swoootie]

Hi all,

I have an IF statement where I want code in a different macro executed when a cell is populated with a specific value. My code thus far is below:

Sub RUNOPT()
Sheets("Main Page").Select
If Sheets("Main PAGE").Range("L15") = "A" Then Call RUNA
If Sheets("Main PAGE").Range("L15") = "B" Then Call RUNB
If Sheets("Main PAGE").Range("L15") = "C" Then Call RUNC
If Sheets("Main PAGE").Range("L15") = "D" Then Call RUND
End Sub

Is it possible to add such conditions to an IF statement. I'm not entirely sure what is going on.

Any help would be greatly appreciated.

Thanks

 

[VoG]

Maybe like this

Sub RUNOPT()
Sheets("Main Page").Select
Select Case Range("L15").Value
    Case "A": Call RUNA
    Case "B": Call RUNB
    Case "C": Call RUNC
    Case "D": Call RUND
End Select
End Sub

 

[JLGWhiz]

Hi all,

I have an IF statement where I want code in a different macro executed when a cell is populated with a specific value. My code thus far is below:

Sub RUNOPT()
Sheets("Main Page").Select
If Sheets("Main PAGE").Range("L15") = "A" Then Call RUNA
If Sheets("Main PAGE").Range("L15") = "B" Then Call RUNB
If Sheets("Main PAGE").Range("L15") = "C" Then Call RUNC
If Sheets("Main PAGE").Range("L15") = "D" Then Call RUND
End Sub

Is it possible to add such conditions to an IF statement. I'm not entirely sure what is going on.

Any help would be greatly appreciated.

Thanks

Yes. Have you tried it?

 

[Swoootie]

Hi. Thanks for your responses. it doesnt seem to be doing anything at all though.

 

[Swoootie]

Apologies. I was referencing a module not the sub procedure. Now corrected.

Thanks for all your help.

 

[JLGWhiz]

Thanks for the feedback.
Regards, JLG