PDA

View Full Version : Solved: whats the difference



CatDaddy
05-29-2012, 09:44 AM
whats the difference between

Worksheet_SelectionChange(ByVal Target As Range)

and

Worksheet_Change(ByVal Target As Range)

Paul_Hossler
05-29-2012, 10:35 AM
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
05-29-2012, 10:54 AM
thank you!

snb
05-29-2012, 12:01 PM
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).