Search Userform

[sukyb1]

HELP....im trying to create a excel sheet which does the following
I have the following colums...ProjNo, ProjName, EstimateNo, Estimator, Date Archived...I want a command button which once clicked brings up a useform
I want to add a userform which a user can type in the ProjNo and EstimateNo and in a box the Date Archived with automatically show up...
How do i do this?

[royUK]

Take a look at the Database Form example here

http://www.excel-it.com/vba_examples.htm

[sukyb1]

these dont work...can anyone else help??
In the attached file is an example...
When the search button is clicked a useform comes up.
in the userform you have to type the estimate no and project no and then click search, on clicking search it should look for the estimate number and column number in the same row, if a match is found then the date or archive is put in label 4 and if nothing is found then label 4 should be blank.
Both ProjNo and EstimateNo have to be typed in.

[royUK]

What dosn't work? The example contains code to search, it simply needs adapting for your purposes.

Why would you need to search for estimate number & project number. find the estimate number & the project number is on the same row