Excel VBA Search Form

[jjward101]

Hello. I have a working userform to add data to the next available row, and have been trying to create an additional userform to search based on project number, quote number, or sales rep and return the results within the new userform. RIght now I am not trying to make edits within the form...just pull the data back for reference. My vba knowledge is primarily self taught and limited, so I have been trying to do this by piecing together bits and chucks of code found via google...but just cannot seem to make it work.

Could someone take a look at this and make a recommendation as to the best way to accomplish this? (Sample sheet attached)

[carlmon]

Why go through the trouble of writing a macro when Ctrl + F is a viable option?

I can write you a macro to look up something, but Ctrl + F already does exactly what you're asking for.

[jjward101]

Because the people who are going to be using it are less than savvy, and clicking the button for the form will actually be less of a headache.

[carlmon]

Do you want one button to search for everything or a single button for each individual thing? I.e. Project number, quote number, etc.

[jjward101]

I am open to either, so long as it works. Thanks very much