Very easy question (Excel/VBA)

Topic

New Reply

Here’s a quick one I could use help with:

How do you stop (cancel) a macro in an If….Then…Else statement?

All I’m trying to do is say that IF the user clicks the No button, THEN stop the macro, ELSE, carry on running through the lines following after right down to the End Sub.

Also, can anyone recommend any good sites for ‘VBA 101’ or similar? The sort of thing that will start with “This is how we tweak a message box” and “This is why we declare our variables”.

Many thanks.

Reply | Quote

Replies

Have you tried this?

IF ‘click on No button’
THEN END SUB
ELSE

It sounds logical to me but i’m sort of new to VBA

Reply | Quote

You can use this to exit the current sub:

If endcondition then
Exit Sub
End If

There is also the End statement, which stops execution immediately and therefore can make an almighty mess if you’re not careful to clean up before using it. In fact, best not to use it at all!

BTW drkrealm has an excellent spreadsheet with links to all sorts of tutorials; I think he posted it recently.

HTH

graeme

Reply | Quote

Thanks guys. Exit Sub was what I was looking for.

See, easy isn’t it?

Reply | Quote