Stop Sub if Condition is True

I'm writing my first Macro that contains an IF statement, and after 15 minutes, I've decided to pop my head in and ask for help.

I have a macro that already works the way I want it to. But now, I want to add a condition that has to be met before it runs.

All I have so far is

Please Login or Register  to view this content.

I want it to then stop running if CF5=1. If CF5=0, I want it to keep going.

I can't figure out the proper syntax. If I try putting "Stop" after the MSGBOX I get a message about an End of Statement. I've also tried using ELSE and ENDIF, but I'm getting an error saying there's no "IF".

I need help! Thanks in advance!

Actually, that worked just fine. I put the first line in front of my macro, and the ret of it after. Thanks!

Could you tell me in what way I was using "Stop" incorrectly?

As for the "Value", thanks for the tip. I've learned all my VBA from Google on an as needed basis, so any shortcuts are appreciated!

Wasn't a bad guess then

Happy to help.

Have fun with the learning. We're here to help!

BSB