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!
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).
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.