Solved: whats the difference

[CatDaddy]

whats the difference between

Worksheet_SelectionChange(ByVal Target As Range)

and

Worksheet_Change(ByVal Target As Range)

[Paul_Hossler]

If the Active Cell is A1 and you click A2, that's a "SelectionChange"

If the Active Cell is A1 and has 100 in it, and you change A1 to 200 and hit enter, that's a "Change"

Either can happen either via KB or VBA

More details in online help: "worksheet object events"


Paul

[CatDaddy]

thank you!

[snb]

In
Worksheet_SelectionChange(ByVal Target As Range)

Target is the cell you enter

and

in
Worksheet_Change(ByVal Target As Range)

Target is the cell you 'left' (where the change took place).