#1
|
|||
|
|||
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. |
Tags |
multiple criteria, next & previous, user form search |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find the row number based on criteria | Marcia | Excel | 1 | 11-15-2021 10:13 PM |
Userform textbox control missing/invisible; can't find, use or replace it; how to salvage work on a | marceepoo | Word VBA | 8 | 05-01-2020 09:56 PM |
Adding a check box to filter criteria | trevorc | Excel Programming | 3 | 11-13-2018 12:19 PM |
Create a unique list of values that match a criteria, sorted in order of another criteria | BradRichardson | Excel | 2 | 01-03-2017 12:25 AM |
Find criteria, then paste- code is overwriting data | ufopilot | Excel Programming | 0 | 02-18-2016 10:14 PM |