How to ignore user input during macro execution?

  • Thread starter J. Andrew Smith
  • Start date
J

J. Andrew Smith

I have a macro that asks two yes-no questions to start. I generally answer
them yes and no by hitting Y-N very quickly. Sometimes I'm so quick that the
N goes into the currently selected cell, where Excel thinks I'm entering a
string. When I hit Escape, the macro stops, and the N is still there.

How do you get a macro to ignore all user input unless and until a message
or input box comes up?
 

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

User initiated break/actions during macro execution 1
How to wait and check for user input? 3
Exiting a VBA Macro by user intervention 1
Changing Color of tab/background when record is complete 1
Problem assigning macro to button? 2
VBA to find filename and replace 2
I want to add a 2 sec pause to a 'Next Record' event in a macro 1
I want to add a 2 sec pause to a 'Next Record' event in a macro 2

Top