I'm using a rather large spreadsheet with 26 columns. In the upper left of the sheet, I've use a DSUM function to allow the user to rapidly fill in any desired filter criteria. This portion works great. To make things even easier for the user I created a UserForm1 to fill in criteria vice having to scroll through 26 columns. The form does not include every field but does include the mose important ones. On the users initial filter query things work great - but I added a "Reset" CmdBtn to clear the filter TxtBoxes and allow the user to run another query. This does not work on the form. Basically, I cleared the TxtBoxes of thier value and cleared Row 4 (where the criteria is entered on the spreadsheet for the DSUM function). The "Reset" returns a value of "0." instead of the DSUM of all the data without crteria. If I clear the filters directly off the spreadsheet without the form, then the DSUM function does return the DSUM of all the data which is what I want the "Reset" button to perform. I've attaced a sampling of the larger spreadsheet for review and below is the code behind the UserForm1. Any help to show me how to get the "Reset" button to work is greatly appreciated. The "Filter" button at E2 will activate the form.
Please Login or Register to view this content.
Bookmarks