Creating a Userform to Search for Data

To anyone that can help,

I'm pretty new to VB and anything I know about it has been picked up as I go along.

I'm trying to create a userform which acts as a filter/search form of sorts. I need it to be in a userform format so I can't just use the standard filters in excel. What it is is there is a userform with the following fields: Project Name, Project Number, Project Value, Plant, Region, Engine, IPT Lead/Buyer, Status, Quarter. The user fills out the form either manually or by options in dropdown menus and then presses search. What I need to understand how to do is how to code the form to find whatever has been input into the different sections. The form will be searching through a large spreadsheet in excel.

My first thought was that because each of those fields in the large spreadsheet are always in the same column, there could be some way of of specifying ranges to match the words or something of that nature.

Any help would be greatly appreciated.

Thanks in advance.

Hi again,

It's only been 2 days, but relative to this kind of forum, that's a while as I see other threads being replied to within hours, sometimes even minutes. PLEASE any help would be greatly appreciated. I have a rough idea of what to do:

Please Login or Register  to view this content.

From here I do not know what to do-I know that the above code sort of defines what the button should do, but how do I then get it to call up/show the data on the same spreadsheet?

Thanks in advance.

Hi,

I can't open that because there are very strict web browser settings on at work, is there any other way to send me that file?

Many thanks for your help.