A
Anthony
Hi,
I have this code which checks the value in cell A1, if it is not equal to a
certain value then run the Banker macro
If it is the show msg box
If Range("A1").Value = 15 Or Range("A1").Value = 12 Or Range("A1").Value = 9
Or Range("A1").Value = 6 Or Range("A1").Value = 3 Or Range("A1").Value = 0
And Range("ab1").Value = "" Then
MsgBox "Banker!", vbExclamation, "test"
Banker
Else
If IsNumeric(Range("B9")) And Range("B9") > 0.5 Or Range("B9").Value = "1p"
Or Range("B9").Value = "10p" Or Range("B9").Value = "50p" Then
MsgBox "Box already picked..chose another !", vbExclamation, "test"
what I want added to the above is a further check to see if cell AB1 is
populated with 1 if it is then run macro Banker2 if it isn't run Banker
hope this makes sense
I have this code which checks the value in cell A1, if it is not equal to a
certain value then run the Banker macro
If it is the show msg box
If Range("A1").Value = 15 Or Range("A1").Value = 12 Or Range("A1").Value = 9
Or Range("A1").Value = 6 Or Range("A1").Value = 3 Or Range("A1").Value = 0
And Range("ab1").Value = "" Then
MsgBox "Banker!", vbExclamation, "test"
Banker
Else
If IsNumeric(Range("B9")) And Range("B9") > 0.5 Or Range("B9").Value = "1p"
Or Range("B9").Value = "10p" Or Range("B9").Value = "50p" Then
MsgBox "Box already picked..chose another !", vbExclamation, "test"
what I want added to the above is a further check to see if cell AB1 is
populated with 1 if it is then run macro Banker2 if it isn't run Banker
hope this makes sense