View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Graham Y Graham Y is offline
external usenet poster
 
Posts: 66
Default Worksheet_SelectionChange allow multiple ranges to be selected

I have an input form that pops up when a user selectes a cell, but I want
them to be able to use ctrl to pick non-contiguious cells, but as soon as I
let go of the mouse button, to select the next cell, the form pops up.
I know I've done this before because I have put code in to check the range
of columns selected, which I have tested.

Any Ideas how I stop the form poping up until I have stopped selecting cells?