I'm a relative newbie to VBA, meaning I'm able to find code that creates what I'm trying to do and manipulate it to suit my needs and/or use record and manipulate the resulting code to make it do what I want. Coding from scratch is....iffy? Iffy works.

I've created a userform that allows user to enter data into a spreadsheet with 12 columns. It uses combinations of text and combo boxes.

Spreadsheet is laid out as follows:
a b c d e f g h i j k l
Task Date Store Name Subject Contact Company Details Next Action Follow-Up/Due Status User

My userform allows user to scroll through all records, edit the record, and saves the edits. It also autofilters four fields, clears the filter, shows all records, and reverts to the spreadsheet after filtering. All working well.

My issue is this:

I'd like to create a simple text box search that will allow a user to enter one or more search terms for the following columns - Date, Store, Name, Subject, User - and autofilter all results for those terms. If possible, I'd like to repopulate the userform with the data and use the existing previous and next buttons to scroll through just the searched results.

I've included the code for the whole userform below. (Overkill, I know, but better than not enough info.) I've tried and discarded I don't know how many attempts to do this on my own. If someone could point me in the right direction, I'd seriously appreciate it. I've been banging my head against this for a few days now and it's starting to result in gray hairs showing through the dye job! Thanks!!!!

Please Login or Register  to view this content.