I am using a form in Mic. Excel. On the form, it contains CheckBoxes, TextBoxes, ComboBoxes, and CommandButtons. What I am trying to do is make a button so when the user clicks it, it will reset the whole form. I.E. Clear all the checkboxes, comboboxes, and textboxes. Well, it works but not exactly. What it does is every time you click the button, it clears one object. So, you have to keep clicking the button, clearing one object at a time until the form is clear. What am I doing wrong? Here is the code I am usin:
This is one set of code I tried:
cbxEmployeeName.Text=blank
ccbxSeries6.Value=False
ctxtFirstName.Text=blank

Then I tried another set of code and it does the same

With frmReferral
.cbxEmployeeName.Text=""
.ccbxSeries6.Value=False
.ctxtFirstName.Text=""


Am I doing something wrong???
Someone please help me. I will even send you the form and let you look at it.