User Form Search

[SoyuzGRU]

Background

I am looking to automate excel and have an excel that includes 3 sheets:

Master Sheet (Sheet1) - All information from user forms are stored here (sheet will be locked)
Data Validation (Sheet2) - Information from user form combo boxes are here (sheet will be locked)
Menu (Sheet3) - User interface with buttons that open user forms

Assistance

I am trying to setup a user form where a user can view records in the Master sheet through the input of up to 3 text box fields (All labelled by their default names "TextBox1", etc.). Once the user hits submit, I'd like the form to compile all rows of data that matches the search criteria to a List Box at the bottom of the form.

On the more complicated side, the Master sheet has about 11 columns of data in one row. I want all this data displayed, but the user is only filtering through 3 columns as followed:

User Form TextBox1 - Searches Master Column D
User Form TextBox2 - Searches Master Column E
User Form TextBox3 - Searches Master Column F

I've looked at countless tutorials, and tried a few codes found in them but can't seem to get the results desired. While I am a novice to VBA I'd appreciate a short explanation if possible on any codes provided.

As always, I appreciate any help

 

[SoyuzGRU]

You have problems, but it's not with my code.
Nowhere in my code do I have those instructions that you put in the image.

That's why I wrote to you, forget your code and try my code.

If you want me to review your code, you'll need to share your file.

You could upload a copy of your file to a free site such www.dropbox.com or google drive. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

I've uploaded a copy of the workbook that does not contain any confidential information to Google Drives and can be found here:

Meet Google Drive – One place for all your files

I really appreciate all your help and patience with this.

*On another note as well, I haven't updated the UserForms by deleting the command buttons, but will if you're able to get it running

 

[DanteAmor]

I sent you an access request. ?