run macro whenever a cell value is FALSE?

[aberenguel]

Can someone explain how I can get excel to run a macro whenever the value of a certain cell is FALSE?

 

[onlyadrafter]

Hello,

How is the data in the cell obtained? Entered or formula?

 

[aberenguel]

formula...so it could change depending on values pasted into another tab in the workbook.


thanks,

 

[ACommandLineKindaGuy]

Sounds like a job for the WorkSheet_Change Event.

Create that for the sheet you're monitoring, and then add code to check what the cell's value in question is, and run the appropriate code.

 

[ACommandLineKindaGuy]

Sounds like a job for the WorkSheet_Change Event.

Create that for the sheet you're monitoring, and then add code to check what the cell's value in question is, and run the appropriate code.

 

[ACommandLineKindaGuy]

Sounds like a job for the WorkSheet_Change Event.

Create that for the sheet you're monitoring, and then add code to check what the cell's value in question is, and run the appropriate code.

 

[onlyadrafter]

Hello,

If the value can change from anywhere within the workbook, put this code into the THIS WORKBOOK code window.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Sheets("Sheet1").Range("A1").Value = False Then
       'your code here
End If
End Sub

 

[aberenguel]

thanks guys!!!!!!