Ok I've done a little research and got this but still doesn't work (and when I go to assign it to a button it doesn't even show as an option??) I have a tab called "Dashboard" where the buttons are and the tab "Bet Angel" is where the commands need to take place, specifically in cells L9 (The word "BACK") and O9 (The word "PLACED")
Private Sub Worksheet_Change (ByVal Target As Range)
‘ BACK ONE
Sheets(“Bet Angel”).Cell(12, 9) = “BACK”
If Target.Address = “$L$9” Then
Application.EnableEvents = False
If Sheets(“Bet Angel”).Cell(15,9)=”PLACED” Then
Sheets(“Bet Angel”).Cell(12,9).ClearContents
Sheets(“Bet Angel”).Cell(15,9).ClearContents
Else
Application.EnableEvents = True
End if
End Sub
Please can anybody see why this wouldn't be working for me?
Cheers,
CPerry.