Run Macro Automatically when data validation changes

[rgkgk]

Hi All,

Need Help:

Automatically run macro when data validation value changes:

Ex : Range E4 has a data validation, list contains 5 values (Red, Blue, Green, Amber, White)
if E4 value = Red then run macro

Thanks,
GK

 

[ZAX]

Type This Code In The Sheets' Code Page And Replace The 7th Line With The Macro Name:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$E$4" Then
Exit Sub
Else
If Target.Value <> "Red" Then
Exit Sub
Else
'Type The Macro Name Here
End If
End If
End Sub

ZAX

 

[rgkgk]

Hi ZAX,

Its not working...

Thanks,
GK

 

[ZAX]

It's Working Perfectly,PLZ Follow The Steps:
1.Open Visual Basic Window.
2.Look To The Left You'll Find The Following:
a)Module1
b)This Workbook
c)Sheet1("The First Sheets' Name Here") EX: Sheet1(Data)
Double Click The Sheet That Has The Name Of The Sheet Which Has The Validated Cell.
3.Paste My Code.
4.Change The 7th Line Of Code With The Macro Name EX: "Macro1".
ZAX

 

[rgkgk]

Thanks ZAX