Maka
05-02-2005, 09:44 AM
Hi, i have no way of explaining this clearly so i will try my best.
I developed a VBA add-on that works with a userform. I access the userform from a button created in workbook_open code. The thing is the userform can read data form the sheets and create a structure ("type ...."). from the userform i can print some reports and modify the data to change the reports. Sometimes, moslty after printing a report, if I close the userform and then call it again form the button, all the public variables i had created and read before is lost and also all the changes i created earlier. Is there any way the public variables "survive" several closing and openings of the userform?
hope its clear enough.
I developed a VBA add-on that works with a userform. I access the userform from a button created in workbook_open code. The thing is the userform can read data form the sheets and create a structure ("type ...."). from the userform i can print some reports and modify the data to change the reports. Sometimes, moslty after printing a report, if I close the userform and then call it again form the button, all the public variables i had created and read before is lost and also all the changes i created earlier. Is there any way the public variables "survive" several closing and openings of the userform?
hope its clear enough.