syntax for If/Else/End If

[HeyInKy]

Keep getting Else Without If errors... someone help me with the proper syntax for my code:

Please Login or Register  to view this content.

Please and thank you!!

[AB33]

I am not sure why you have and after then, but this will get rid of the error, though it might not be correct

Please Login or Register  to view this content.

[6StringJazzer]

When you put the a statement after the Then on the same line,the whole line stands alone as a single statement. It is not part of an If/End If structure. To fix that, move the statement after the Then onto the next line.

Because you are checking chk to be either True or False your logic can be further simplified to

Please Login or Register  to view this content.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[6StringJazzer]

Upon reading AB33's post I realized that you almost certainly have another error.

Please Login or Register  to view this content.

This is syntactically legal but I am 99.9% sure it's not what you intend.

I suspect you really want to do two separate things:

Please Login or Register  to view this content.

The And is logical operator. It does not mean "do this And do that".

[HeyInKy]

Yes - thanks to all - I realized I do not need the AND operator...

and actually, playing with the provided suggestions, I have two sub routines that appear (at first testing) to accomplish what I need without using ELSE and/or END if...

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Thanks again!

[TMS]

You're welcome.