Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-17-2021, 02:47 AM
Denny57 Denny57 is offline Adding Criteria and find next in customised userform Windows 10 Adding Criteria and find next in customised userform Office 2010
Novice
Adding Criteria and find next in customised userform
 
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
Reply

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 Criteria and find next in customised userform Adding a check box to filter criteria trevorc Excel Programming 3 11-13-2018 12:19 PM
Adding Criteria and find next in customised userform 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft