criteria form in excel with a hidden worksheet

  • Thread starter Thread starter Okolo
  • Start date Start date
O

Okolo

I have a datasheet in excel that I want to put a form on the front end for.
Based on criteria entered into the form, I want it to bring back results from
the datasheet.
 
Hi,
you have a text box where you enter some information and then retrive
information from you worksheet, the below example is one I'm using where I
enter the project number to be deleted it check the project in column E and
it pull the client name from column C



res = Application.Match(Me.TxtProjectCode.Value, _
Worksheets("Projects").Range("e:e"), 0)
If IsError(res) Then
If IsNumeric(Me.TxtProjectCode.Value) Then
res = Application.Match(CDbl(Me.TxtProjectCode.Value), _
Worksheets("Projects").Range("e:e"), 0)
End If
End If

If IsNumeric(res) Then


'fill out information
Me.TxtClient.Value = .Cells(res, "C").Value

hope this helps
 
Back
Top