Help with running a macro if a value is true.

[owen4512]

I'm not sure this is possible but is there a way i can tell excel to run a macro if a criteria is met.

For example;

If Range("D15").Value = "Iawn I Fwcio" Then
run macro "nameofmacro"

this is what i have so far,

thanks in advanced,

Lee

Sub mewbynnuDataSioe()


'
' Mewnbynnu_Data_Sioe Macro
'
' Keyboard Shortcut: Ctrl+Shift+Q
'
If Range("D15").Value = "Iawn I Fwcio" Then
if Range("D15").value call 'turnwhite'
Range("D14").Select
ElseIf Range("D15").Value = "Dyddiad Anghywir" Then
MsgBox "Mae yna dyddiad anghywir wedi ei fewnbynnu! Mae angen newid hyn er mwyn cario ymlaen!"

End If


End Sub

 

[Comfy]

Hi Lee,

If Range("D15").Value = "Iawn I Fwcio" Then
call turnwhite
Range("D14").Select
ElseIf Range("D15").Value = "Dyddiad Anghywir" Then
MsgBox "Mae yna dyddiad anghywir wedi ei fewnbynnu! Mae angen newid hyn er mwyn cario ymlaen!"

 

[owen4512]

Thank you very much. Worked first time