-
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.
-
firstly, you would have to put an "end with" on the end of your "with" code.
a few suggestions
1. make sure you have the right control names
2. textthingy.text = ""
3. Delete the error handling to see what is going wrong, if something is?
4. If that doesn't work, send me the spreadsheet and i'll try to fix it - if you want???
