transfer variable values between user forms?

This depends a bit on how you have the first and second forms related to each other. Does the first form "Show" the second form? It is generally not best to use global variables if you can avoid them. If you define a function/sub on the second form, the first one can pass the data to the second through this routine after the second form is loaded.

If you have some sample code, please post it.

I can't see why you need two Userforms. It can easily be done with one

royUK may have the best solution for your needs. If you still feel that it is best to use 2 forms, attach a sample workbook to your reply.

Originally Posted by blane245

royUK may have the best solution for your needs. If you still feel that it is best to use 2 forms, attach a sample workbook to your reply.

I think you're right, that it can be done with 1 forum. What I'm struggling with now is taking the information from the second combo box and then putting it into the subs to generate the value that goes into the third combo box.

The problem is that the 2nd box is dependent on the 1st, and the 3rd is dependent on the 2nd. When I'm changing the first box it immediately selects a value for the second, which triggers an event on the 3rd. I only want that event to happen if the user selects a value from the second combo box.

What do I need to put around the code in order to post it?

also, I would post code if I knew how to use the tags

To use the code tags, you type [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] after it.

To use 2 forms for this:
Let's say your forms are Userform1 and Userform2. In Userform2, add two public variables - for example:

Please Login or Register  to view this content.

then in your first form you can use:

Please Login or Register  to view this content.

and your second form can then simply refer to Company and Account as needed.

If you have one form and want to selectively disable event processing, then you need a boolean flag declared at the top of the module:

Please Login or Register  to view this content.

then the first line of all of your event routines should be:

Please Login or Register  to view this content.

Then when you want to suppress events being triggered by another routine, you simply set the variable to true:

Please Login or Register  to view this content.

Does that make sense?

If CardNumber is a sub, it has no properties so you cannot refer to its Text property.
Also, your code should be:

Please Login or Register  to view this content.