aberenguel
Board Regular
- Joined
- Aug 10, 2006
- Messages
- 83
I want excel to run a macro i've created whenever the value of a cell is equal to FALSE. I'm sure this is easy to do but i'm having trouble getting it right.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if a cell value ever = false run macro
- Thread starter aberenguel
- Start date
Excel Facts
Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
fridgenep
Board Regular
- Joined
- Mar 26, 2006
- Messages
- 73
...
Hi,
p.e.:
your macro:
your worksheet:
Hi,
p.e.:
your macro:
Code:
Option Explicit
Sub test()
MsgBox "my macro"
End Subyour worksheet:
Code:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If ActiveSheet.Range("A1").Value = False Then test
End Sub
Upvote
0
