Some Controls On UserForm Retains Data - How Do I Stop This??
Posted by Angie Dickinson on January 22, 2002 3:51 AM
I have 2 combo boxes on my form along with other controls. When I click on Add Record to update the worksheet, I get a message box asking if I want to add another record. When I click on Yes, the userform reappears with all the other controls on the form blank, except for the 2 combo boxes, these still have the data from the previous transaction. Is there any way I can get around this?