criteria form in excel with a hidden worksheet

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.
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Cascading combos in datasheet 0
Populate query in a subform based on selection from combobox in main form 0
Filtered Data-Linking 3
Access Open Form with WhereCondition 6
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Multiple results 1
Paste all sheets into one master sheet 4

Top