Macro to Run if the 'If' is true else custom message to be displayed.

Hello,

I have the code that is ready and working, now I want to add one condition at the start. If the condition is true then macro should run else message box should pop up. I thought of something like this

Please Login or Register  to view this content.

But I get an 'Complie Error: Else Without If', can some one please point out what I am doing wrong here.


Thanks,
Aadesh Gandhi.

Originally Posted by HaHoBe

Hi, Aadesh Gandhi.,

Please Login or Register  to view this content.

Ciao,
Holger

Hello Holger,
Your code looks similar to mine, so was this just a formatting thing?


R/
Aadesh

Originally Posted by HaHoBe

Hi, Aadesh Gandhi.,

close but no cigar...

Your If-statement ends right at the end of the first line as you wrote the Then part right behind the Then. Doing it that way leaves you just with the TRUE condition, no Else-statement is possible for this one-liner.

Mine was structured like this:

Please Login or Register  to view this content.

And there´s no comment from the compiler about my code, is it?

Ciao,
Holger

Nope no issues with your code. It does work great! I am still learning things so want to understand if my logic was flawed or my formatting.

Thanks for your help!

Aadesh

Originally Posted by HaHoBe

Please do not quote whole posts

Holger,
Will follow it moving forward.


Thanks,
Aadesh