View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default 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