Pop-up Message on error

[TomBP]

FunkySquid,

I changed the original code behind CASTROL RECEIPT button with your
code. When I press it it gives the following error:

[image:
http://i54.photobucket.com/albums/g115/TomBP/receiptcastrolsyntax.jpg]

 

[FunkySquid]

The 'Then' needs to be on the same line like this:

If Application.Names("ProductCodeReturned").RefersToR ange <> "C"
Then

FunkySquid

 

[FunkySquid]

That did post correctly. Anyway, just make sure it's on the same line.

The 'Then' needs to be on the same line like this:

If Application.Names("ProductCodeReturned").RefersToR ange <> "C"
Then

FunkySquid

FunkySquid,

I changed the original code behind CASTROL RECEIPT button with your
code. When I press it it gives the following error:

[image:
http://i54.photobucket.com/albums/g115/TomBP/receiptcastrolsyntax.jpg]

 

[TomBP]

FunkySquid,

I put the Then behind the line as you said. But another error pops up.

[image: http://i54.photobucket.com/albums/g115/TomBP/compileerror.jpg]

I put the "ange" closer to "RefersToR" so that it makes "RefersToRange"
which looks pretty logic to me. After that another syntax error pops
up:

[image:
http://i54.photobucket.com/albums/g115/TomBP/syntaxerroragain.jpg]

Fun fun fun

 

[FunkySquid]

Same as before, the vbInformation should be on the same line. It all
went a bit weird when I pasted it.

 

[TomBP]

It works like a charm now.

Thanks for your time and help FunkySquid