Macros

  • Thread starter Thread starter Lord Of The Morning
  • Start date Start date
L

Lord Of The Morning

Does anyone know why when after I typed information into a cell and click on
a macro the macro will not function unless after I typed the information
into the cell I click enter or tab out of the cell then the macro becomes
active.
Is this just something I have to deal with?

Nick
 
Macros do not work when in edit mode, which is the mode you describe.
Entering or Tabbing takes you out of edit mode and your macro can now operate.

Gord Dibben Excel MVP XL2002
 
You must log in or register to reply here.

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

Macro Stoped Working 2
worksheet change macro activation 5
Moving a bunch of data 1
Macro 9
Upgrade issue? 1
Pasting cell contents into a macro 1
macro to select a range from a set cell to a specified cell 6
Executing a macro command 2

Back
Top