Running macro when cell is being edited

C

Chris Watts

When editing a cell, you can press Tab at any point and go to the next cell.
I have written a CleverTab macro that tabs to the next cell in use. I works
fine when not editing a cell but will not run when the cell is being edited.
So I need to Tab or CR out of edit mode before I can get this, or indeed any
other, macro to run. Is there any way around this?

I have written several vba macros that do different things and all exhibit
the same characteristics.

TIA
Chris
 
B

Bernie Deitrick

Chris,

There is no way around this behavior - VBA is inactive when Excel is in Edit mode.

HTH,
Bernie
MS Excel MVP
 
C

Chris Watts

Drat!
Thanks Bernie.
cheers
Chris

Bernie Deitrick said:
Chris,

There is no way around this behavior - VBA is inactive when Excel is in
Edit mode.

HTH,
Bernie
MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu Macro Not Executing - Need Help 1
Macro warning in word 1
Cell data entering slow! 0
Need Help with Macro Security 1
One note creating multiple tabs when collaborating? 0
How to clear prior search terms from Navigation Pane 0
Crating User Form to Add Names 1
Running macro when communicator message is received 0

Top