[excel vba] search form with 2 criteria

[p27br]

hello

I need to do the following : I have an excel workbook with one worksheet. The first column is populated with data.
the user wants to generate a new sheet in this workbook with only the records from the first sheet containing the matching criteria.

I have setup a user form with 2 textboxes for the search criteria, and 2 checkboxes so that the user can choose criteria1 and/or criteria2

could someone help me write the procedure that searches the records and outputs the result to the new worksheet ?

thanks a lot

 

[SkipVought]

Hi,

You could use Data/Get External Data/New Database Query and set up a simple parameter query. Could be done with no VB code at all.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[PHV]

As a starting point you may use the macrorecorder when you manually set an AutoFilter or an Advancedfilter.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[p27br]

skipvought

good idea, but when i select the workbook in the new database query wizard, it says " This data source contains no visible tables

 

[SkipVought]

Select the [Options] button in the Add Tables window and check ALL the boxes.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[p27br]

thanks

it seems to work now i checked system tables