PDA

View Full Version : Adding a 2nd Macro



RINCONPAUL
12-09-2015, 11:15 AM
I have code written that when a countdown timer reaches zero it causes a cell function to change a value from 0 to 1 and this fires the macro Copy_Race.
However, I have another macro called Trigger_Bet which I would like to be triggered at the same time. I've never been able to get this concurrent trigger to work and have had to run two instances of the workbook, one to copy, one to trigger bet. Is there any way to combine the two?


Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
With ThisWorkbook
If .Sheets("Bet Angel").Range("B69").Value <> 1 Then
.Sheets("Bet Angel").Range("B70").Value = 0
End If
If .Sheets("Bet Angel").Range("B69").Value = 1 And .Sheets("Bet Angel").Range("B70").Value <> 1 Then
Copy_Race
.Sheets("Bet Angel").Range("B70").Value = 1
End If
Application.EnableEvents = True
End With
End Sub