Running macro when cell is being edited

  • Thread starter Thread starter Chris Watts
  • Start date Start date
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
 
Chris,

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

HTH,
Bernie
MS Excel MVP
 
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...
 
Back
Top