View Single Post
 
Old 12-17-2021, 02:47 AM
Denny57 Denny57 is offline Windows 10 Office 2010
Novice
 
Join Date: Dec 2021
Posts: 1
Denny57 is on a distinguished road
Default 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.
Reply With Quote