Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets events
Where is a good site to explain the difference between the following VBA codes?
Worksheet_Change Worksheet_SelectionChange Looking at Walkenbach 2003 (VBA book) pages 621-626. I'm confused is SelectionChange before you hit enter and Worsheet_Change after you hit enter? If it is possible to have both is there an order that has to be followed. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets events
Brad,
I'm not sure you'll get a better reference site/book then JWalk Worksheet_SelectionChange Is just that and has nothing to do with changing the contens of a cell. change the selection to a different cell and the event fires. Worksheet_Change This requires a cell value on the sheet to be changed but won't be fired if a formula output changes unless it was a cell on the same sheet that caused the formula value to change. It isn't linked to ENTER. Change a value of a cell and TAB out and the event fires. One place where the unaware can really fall over is that if you use worksheet event code to change a cell value then that calls the event again so you get another call. have a look at enableevents for how to get around this. Mike "Brad" wrote: Where is a good site to explain the difference between the following VBA codes? Worksheet_Change Worksheet_SelectionChange Looking at Walkenbach 2003 (VBA book) pages 621-626. I'm confused is SelectionChange before you hit enter and Worsheet_Change after you hit enter? If it is possible to have both is there an order that has to be followed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to compare times of events btwn worksheets | Excel Worksheet Functions | |||
How do i create a set of worksheets indvidual events to a master | Excel Discussion (Misc queries) | |||
do events? background events | Excel Programming | |||
Any mouse events for Worksheets? | Excel Programming | |||
How to trap KeyDown Events For Worksheets ? | Excel Programming |