Execute a macro based a text in a column which is constantly changing by formulae

[vijayamani1987]

hi people,

Thanks in advance, and excuse me for my average English.

I am very new to VBA. I have a excel sheet, where cells in column B will change on predefined time frame, ex.5 minutes. I want to execute a macro when any cell in that column comes to have specific text, say YES. Please help me out with this.

Note: The values will change only by formula

 

[Grand]

Hi,
I see. Some how we have to distinguish new "execute" from the ones that are already processed. Can you add an extra column (e.g. column G) to your sheet so it can be used to mark those processed ones?
If the amount of data is not huge then a simple for-loop can loop through column B and look for "execute". Each time the value is "execute" we then should look in the help column and if there is no mark then your macro shall be executed.
Instead of the previous code in Calculate event of that sheet put this code in that event:

Dim Trows As Integer

Trows = ActiveSheet.UsedRange.Rows(ActiveSheet.UsedRange.Rows.Count).Row
'the help column is the G column
For m = 2 To Trows
 If ActiveSheet.Range("B" & m).Value = "Execute" And ActiveSheet.Range("G" & m).Value = "" Then
    MsgBox "This is a new execute"
    ActiveSheet.Range("G" & m).Value = "X" 'this is to mark the row as processed
    'here you can call your macro
 End If

Next m