Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to ignore user input during macro execution?
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? -- J. Andrew Smith Senior Systems Analyst Standard & Poor''s, NYC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to ignore user input during macro execution?
Hi,
Can we see the part of the macro that accepts this input? Mike "J. Andrew Smith" wrote: 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? -- J. Andrew Smith Senior Systems Analyst Standard & Poor''s, NYC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Macro. -- User input for sheet name | Excel Programming | |||
macro that promt user for input | Excel Programming | |||
User initiated break/actions during macro execution | Excel Programming | |||
Manual Input During Macro Execution | Excel Programming | |||
Pausing a macro for user input | Excel Programming |