How to catch "Action Failed" macro error so that the Halt dlg doesn't show

F

FrankBooth

Hi,

I have a Find macro that uses an InputBox (not Application.InputBox)
as the parameter. When I click Cancel to the inputbox I receive the
"Action FAiled" HALT dialog. I do not want this to come up, I just
want it to go back to the main app.

How do I catch this error?

Thanks in advance.

--FB
 
K

Ken Snell

Test the value returned by the InputBox for an empty string (""). If it is
an empty string, then have your macro end and go back to where you want to
go.
 

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

Stopping the "Action Failed" msg when Autokeys macro interrupted 2
Macro Error 1
macro halt on parameter query cancel 3
Halt Macro on Error 7
"Action Failed" in Access 2002 0
How to turnoff the Halt mess in a macro when running a qby cancel 1
Action Failed Error message 1
macro action failed 0

Top