Understanding why the code works

[coys1717]

Hi Below is some code, it does whats needed, but I want to understand why it works so I can adjust it as an when.

Please Login or Register  to view this content.

How does

Please Login or Register  to view this content.

work? also is the absolute address of cell B1 required as the code works with just the relative address, why is that important?

Many thanks

[pjwhitfield]

the Sub line tells the code to pass the cell reference that has changed into the variable Target

so the line you're querying is basically saying "is target = A1?" or "is A1 the cell that has changed?"

The $B$1 would work exactly the same in this instance as B1

[coys1717]

Hi Thanks for the reply, So target.address is telling the code that CELL reference A1 is a now a variable?

I'm looking at the code simplistically and still trying to work out how excel processes the information eg

Please Login or Register  to view this content.

[zbor]

This is for changes on the sheet.
Any cell you typing in the sheet is target cell.

And code will be run whenever you change something.
However, if you don't want rest of the code to be executed you can jump out of the Sub or skip it by IF function.

In your case you will execute code only If Target.Address is "$A$1".

That means for every other target address (i.e. B1) code will run, check is target address A1 and if not it will skip IF part of the code.

only when typing in A1

Please Login or Register  to view this content.

will be True and IF will run within IF statement.

[zbor]

This is another approach when exiting sub:

Please Login or Register  to view this content.

[coys1717]

Thanks for the responses