multiple cell selection/events?

  • Thread starter Thread starter MarkH
  • Start date Start date
M

MarkH

Hi.

If a user has a multiple cell range selected, doesn't
change anything, and presses enter, the activecell walks
through the selected range.

Is there an event which is triggered when <Enter> is
pressed?

The change event isn't triggered because no cell contents
were changed, and the selection is still the same, so that
doesn't trigger either. Only the Activecell changes.

Is there another event which is fired?
 
Have a look at Application.OnKey command



Once the following line of code has been run This will call a sub
called Test1 every time the enter key is pressed. Note this will stop
Excel from activatingthe next cell in your selected area

Application.OnKey "~", "Test1"
 
Thanks... I think that will work fine.

I don't think it will be a problem at all not to have the
next cell activated when Enter is pressed.

Thanks.
 
Back
Top