Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
criteria form in excel with a hidden worksheet
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
criteria form in excel with a hidden worksheet
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 "Okolo" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
colors hidden in excel worksheet | Excel Discussion (Misc queries) | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
form that calls hidden worksheets | Excel Worksheet Functions |