Hi,
Please could someone help me?
First userform = I enter my data
Second userform = I enter my password and save the file
I have moved my 'Submit' VBA code from the first userform to the second userform because I had it entering the data onto the sheet as well as opening the second userform and this was causing the second userform to flicker and delay when opening.
The problem I have now is when the code is trying to find the Textboxes and Checkboxes it triggers an compile error because them boxes are on the first userform.
How do I get the second userform to enter the data from the first userform onto the sheet?
Any help would be very appreciated.
Kind Regards
Dan
Please could someone help me?
First userform = I enter my data
Second userform = I enter my password and save the file
I have moved my 'Submit' VBA code from the first userform to the second userform because I had it entering the data onto the sheet as well as opening the second userform and this was causing the second userform to flicker and delay when opening.
The problem I have now is when the code is trying to find the Textboxes and Checkboxes it triggers an compile error because them boxes are on the first userform.
How do I get the second userform to enter the data from the first userform onto the sheet?
Any help would be very appreciated.
Kind Regards
Dan