passing variable values

[scott micklo]

Hi there

I have 2 variables cust and twopn that I first read the values in the code for the button tags (comes from the DB sheet) on the template worksheet.

I need that data when I click the buttom MAKE PROOF from the user form. My issue is that I can not get the values to pass through to cmdProof code or I get complie error .

Not sure what i am doing incorrectly. I tried useing PUBLIC for teh variables but it wont pass that way either.

Thanks spo much for the help in advance. I am sure it is easy, I just am not sure what needs to be done as I am learning as I go.

Thanks

[Arkadi]

Hmmm, I don't think you can call a sub that is part of a userform code from outside the form?

If you move the cmdproof sub to a module, and have it load or show the userform first, then the sub can still run.

[scott micklo]

Hmmm, I don't think you can call a sub that is part of a userform code from outside the form?

If you move the cmdproof sub to a module, and have it load or show the userform first, then the sub can still run.

Not sure how to move the sub from the userform. This sub will execute once the MAKE PROOF button is clicked. It will be the same with the MAKE PALLET TAGS and PRINT EXTRA. They are all after data is placed into userform and a decision is made what is needed.

[Arkadi]

As I look closer, I assume your first issue is the error message that comes up as soon as you press the button on the template sheet? You cannot name a sub the same as an object on the form, and there is a button called cmdProof as well as a sub in the form.

[scott micklo]

Thanks. I have figured it out! Appriciate it