VBA Userforms Help

Program: Excel 2007

Hello I am trying to do a lot of lines of coding & I have split them up into several userforums. How do I activate one userform if the first one does not match.

Basically I have this line of code going over many times with the numbers changed:

Please Login or Register  to view this content.

You have 6 text-boxes with numbers you can put in but I can only go up with this line of code to the value of 3 & I need to go to the value of 6 so I made another userform, but I don't know how to tell the macro to go to the 2nd userform if the values for all the text-boxes is 4 & over.

Let me know if I need to make anything more clear or if you have questions & thanks in advance for the help!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I don't understand why you have different userforms, that's just making work not to mention trying to do calculations with that.

The calculations are trying to use textboxes from different userforms. You can't calculate using a textbox because it's default is a string, you need to convert the string to a value like Long or Double

It works fine for this set of the code, but adding in the rest makes it far too long. I use text-boxes because the calculations are different for each set.

The code I am using I get from Tristian Class A Sheet & the text-boxes direct it to tables under Tristian Planet Income Sheet. I have far too many characters for the macro & I have several more sheets to go as you can probably tell so I think I need to create a

Please Login or Register  to view this content.

but I am not quite sure if that is right or the easiest way to do it. Once, I know what to do I can do it & I do realize that it will be quite a bit of work. The code is based off of the numbers in Text-box 3 so that is why I have that above.

I can't see any reason for two UserForms, a MultiPage control on one userform would be much simpler.

As I said, you can't use the TextBox entries for calculations , they must be converted to values, e.g.

Please Login or Register  to view this content.

You might want to consider ComboBoxes instead of TextBoxes to ensure correct entries are made and using meaningful names for the controls would make the code easier to understand

It doesn't make sense to have that many lines of code, what exactly are you doing

Your code will not perform a calculation as it is written now.