ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XL2007 (or 2003): Triggering SelectionChange event (https://www.excelbanter.com/excel-programming/442188-xl2007-2003-triggering-selectionchange-event.html)

Conan Kelly

XL2007 (or 2003): Triggering SelectionChange event
 
Hello all,

So I have multiple cells selected. If I tab through the cells in the
selection, the Worksheet_SelectionChange event is not triggered.

Is there another event that is triggered? ...or is there away to get the
Worksheet_SelectionChange event to fire if I'm tabbing through selected
cells?

Thanks for any help anyone can provide,

Conan Kelly



---------------------------
"Smokin' weed kills your brain cells. Drinkin' only screws up your
liver...ya got 2 a those."
- Earl Hickey (NBC's "My Name is Earl")


If Milli Vanilli falls in the woods, does someone else make a sound?



ozgrid.com

XL2007 (or 2003): Triggering SelectionChange event
 
Not that I know of. The selection of cells will fire the Selection Event,
but when you Tab through that selection you are NOT Selecting the next cell
and only activating it.


--
Regards
Dave Hawley
www.ozgrid.com
"Conan Kelly" wrote in message
...
Hello all,

So I have multiple cells selected. If I tab through the cells in the
selection, the Worksheet_SelectionChange event is not triggered.

Is there another event that is triggered? ...or is there away to get the
Worksheet_SelectionChange event to fire if I'm tabbing through selected
cells?

Thanks for any help anyone can provide,

Conan Kelly



---------------------------
"Smokin' weed kills your brain cells. Drinkin' only screws up your
liver...ya got 2 a those."
- Earl Hickey (NBC's "My Name is Earl")


If Milli Vanilli falls in the woods, does someone else make a sound?




All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com