Home |
Search |
Today's Posts |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_SelectionChange allow multiple ranges to be selected
Tom wrote:
<<Events don't fire when you don't do anything. In Excel 2000, the Worksheet_SelectionChange event fires every time you change anything about the selection. For example, say cell $A$1 is currently selected. As soon as you press the shift key and extend the range to include cell $B$2, the Worksheet_SelectionChange event fires. If you then press the Ctrl key to add another cell (say cell $D$5), the Worksheet_SelectionChange event fires again. It fires again when you press the shift key to extend the 2nd area of the selection. -- Regards, Bill Renaud |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
Macro to name ranges for selected worksheets | Excel Programming | |||
Ranges:Target in Worksheet_SelectionChange(ByVal Target As Range) | Excel Programming | |||
named ranges - changing ranges with month selected | Excel Programming | |||
Using selected ranges | Excel Programming |