multiple cell selection/events?

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?
 
M

mudraker

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"
 
M

MarkH

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.
 
Top