Sub is skipping lines of code after Then statement

**chavez982** · 12-05-2012, 09:32 PM

I am just learning how to use user forms, macros and user defined functions and I have ran into a brick wall. I'm trying to execute an If Then statement and even though the conditions are met the lines of code after "Then" are skipped. Here is the macro and the function I'm trying to use. The function works fine, but the sub will not run multiple actions after "Then". I can get it to run one action by putting it on the same line as "If" and "Then", but as soon as I put the code on the next line it just gets skipped. All variables reference input boxes on a user form. By the way I'm on a Mac using Excel:Mac 2011

Please Login or Register  to view this content.

Please Login or Register  to view this content.

trigcalcscreenshot.jpg

**p24leclerc** · 12-05-2012, 09:44 PM

try the following change in your IF statement:

Please Login or Register  to view this content.

The caracter & in VBA is uused to concatenate.

**chavez982** · 12-05-2012, 09:59 PM

It didn't work.

I've attached a screen shot of the user form with the values that I'm trying to use to my previous post. Do you have any other suggestions? Maybe its because I'm using a Mac. I should try this on my PC.

**p24leclerc** · 12-05-2012, 10:18 PM

Ok, I think it is because you are using sideA and sideB name in your macro but you have to refer to the textbox of your userform instead. sideA and sideB are just labels you created. It should be something like:

Please Login or Register  to view this content.

Use the name of your userform and the name of your texboxes.

Same thing for sideC in your code.

**chavez982** · 12-05-2012, 10:32 PM

I figured it out. It was because I was trying to do it on a Mac. I just loaded the same file into my PC and it worked just fine. I guess I'll be working on my PC from now on. Thank you for your help.