Worksheet_Change Event

Hi All,
I want the following code to activate when I change cell A3. How do I specify the code must run ONLY when cell A3 is changed?

Please Login or Register  to view this content.

Thank You.

I want the explanation for this code.can anybody tell me this.

I want the explanation for this code.can anybody tell me this.

The worksheet change event is passed a 'Target' range, that is the cell or cells where you are at the moment.
Mick's code is checking the address of that cell to see if it matches the one you are interested in.
ps. manners never hurt either...

Is BranchCriteria a named range of cells or a single cell

If it is a single cell then you need to add .Address to the command
Without the address command it is testing the BranchCriteria cells value

Please Login or Register  to view this content.

If a range of cells then

Please Login or Register  to view this content.