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

Pasting cell contents into a macro 1
Excel Run macro upon cell edit 0
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Auto Open Macro of external .txt file based on cell reference 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Empty cell warning 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top