Error Message in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I wanted to put an error or info message in my VBA code, so that if the
person running the macro wanted to Cancel instead of Okay an input box and no
changes would be made to the excel document, how would I do that?

I'd appreciate any ideas!

Elise
 
Elise148 said:
If I wanted to put an error or info message in my VBA code, so that if the
person running the macro wanted to Cancel instead of Okay an input box and no
changes would be made to the excel document, how would I do that?

I'd appreciate any ideas!

Elise
Click to expand...

Hi Elise, im as well learning VBA and little by little Im building up on my
experience, but in the past I had a similar question as you,
How about putting in your macro a code for a re-set of your inputs when a
command button is clicked withing your sheet?
 
That's a good idea. The only problem is that I'm sorting data, inserting new
worksheets, and inserting hyperlinks through input boxes.

The first imput box comes up a little ways into the macro. What I am
thinking is that if someone accidentally pushed the macro button, there's no
way to stop the macro and undo the couple steps the macro did before the
input box, besides pushing the "Cancel" button, but that doesn't undo what
the macro did to that point in it...

Any ideas?
 
hi,
just after the input box statement put this...
If MsgBox("do you really want to do this?", vbOKCancel, Confirm) = vbCancel
Then
MsgBox ("Process terminated.")
Exit Sub
End If

regards
FSt1
 
Thanks, I'll give that a try!

FSt1 said:
hi,
just after the input box statement put this...
If MsgBox("do you really want to do this?", vbOKCancel, Confirm) = vbCancel
Then
MsgBox ("Process terminated.")
Exit Sub
End If

regards
FSt1
Click to expand...
 
Back
Top