Goto statment or IF Then End Sub

**TheNewGuy** · 07-09-2009, 09:15 AM

I need a macro that will show a userform if the value of any of three possible chekbox's is true. However if more than 1 checkbox is true I still only need the userform to be shown once. I have tried a few things and am stuck. I think a goto command would work, or if I could simply say If-then-End Sub, but I guess you cant do that. So here is what I have so far, please help if you can, I need to use this for a few different userforms so it is a big stumbling block for me right now. and any help would be greatly appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If you need any more info let me know, but the first sub checks the vaue of a previous userform,and if true calls 1 of 2 subs that determine if the other userform has been called yet, if so the ends the sub, or if not it shows the second userform, ....

Also if you know of a better way to do this please let me know,

Thanks for your time,

**royUK** · 07-09-2009, 09:35 AM

How does it check the previous userform? Are the variables declared as Public or Global?

Do you need multiple userforms? A multipage control on what userform is often a good substitute

**TheNewGuy** · 07-09-2009, 09:52 AM

How does it check the previous userform?

It checks the previous userform by looking to see if the vaue of the checkbox is true.

Are the variables declared as Public or Global?

I am not sure, I know the variables are declared in a public sub, and they are listed in the arguments of the sub that uses them....

Do you need multiple userforms?

I am not sure what you mean, there are 3 userforms that I am dealing with now, 1 to check the values and then 2 different ones that check to see if the other userform has been called yet, and either call it or make sure it doesn't get called.

A multipage control on what userform is often a good substitute

If I use a multipage userform I will still need some code to make sure that the second and third userform only gets called one time each, even though there are three different checkbox's that can call them. Right? I have never used a multipage userform.

How do I tell the macro to go to a certain line in the macro?(the END SUB line) I think that would be the easiest way to do this.

**romperstomper** · 07-09-2009, 10:28 AM

Unless I have misunderstood, you just need an Or statement:

Please Login or Register  to view this content.

**TheNewGuy** · 07-09-2009, 12:29 PM

Man, I though that was going to work perfect ROMPER, but it is calling the two userforms twice each. This is what I changed it, this way I am not even using the other two subs....

Please Login or Register  to view this content.

Can you see why it is calling the userforms twice? And how do I make it stop? Just to clarify, I need it to call the userform if ANY of those three checkbox's are true, but if more than one checkbox is true, I still want the userform to be called only once. Thanks again for all your help!

**romperstomper** · 07-09-2009, 01:57 PM

Where are you calling that sub from?

**TheNewGuy** · 07-09-2009, 02:48 PM

Thank you for the reply, I was just about to edit my last post to tell you I figured it out. I had a second call to the sub that contains the IF-OR statements lurking in the workbook. That is why it was showing the userforms twice. Your suggestion worked perfectly! So again thank you! You have been a big help!