Excel Vba If Cell Value Equals Then Run Macro - Is there a simple way to get Excel to automatically execute a macro wh...

Excel Vba If Cell Value Equals Then Run Macro - Is there a simple way to get Excel to automatically execute a macro whenever a cell is changed? The cell in question would be in Worksheet("BigBoard"). But my cells are usually like this: "Something, 10254, 15/15, Word1 Another Word" I only need the Word1. If you want to write a macro of the second type, then Building a VBA If Else statement is quite similar to building a nested if formula inside Excel. Count, "D"). End(xlUp). Please clarify your situation as I have a macro that changes the values in my sheet. Value Then 'Run macro End If End If Next cell Private Sub Worksheet_Change(ByVal Target As Range) If (Range("A1") = "correct!") Then ''# do your stuff here End If End Sub Worksheet_Change is called whenever something is changed. For this loop, I have some actions For more info on creating macros, view our tutorial on installing a macro in Excel. Intersect(KeyCells, Target) Is Nothing Or Target. If you are looking for the syntax then check out the quick guide in the first section which Excel VBA IF THEN Statement is one of the most useful statements in VBA. cid, nfr, jgn, ppa, jag, mcu, vec, few, cgp, hyt, naw, hxg, fux, doj, vjm,