Adding Criteria and find next in customised userform
Hi.. I have created a userform in Excel 365 for a database that has too many fields for the Built-In Form Command. I have created the code that will allow for the search of unique records in a specified field and populate the corresponding records back into the user form. I have also created that code to allow for changes to such records to be made through the user form
However, I now have a need to search by either single or multiple criteria and return multiple records that match that criteria and where records are not unique
I am hoping to achieve the following.
1) Search by single or multiple criteria
2) Include Find Next / Find Previous functionality
3) Use the current UserForm Text / Combo Boxes to input the search criteria. If this is not possible, then find a way to duplicate the existing user form as happens in the Excel built-in Form.
I have a reasonable understanding of VBA and testing so a generic response / examples should be sufficient.
Ideally, the "Criteria" functionaity of the Built-In Form Command in Excel would be suitable, if someone could assist with the required VBA code
Any help would be most welcome and veery much appreciated.
|