Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with filtering form - newbie
Hi there,
This is my first project in excel VB and have no VB background. Hopin for some help. I have a spreadsheet with 16 fields and I have built a data entry for for it. Below is just an example of what it looks like. Company Type Person in Charge Project com1 customer name1 project1 com2 supplier name2 project2 com3 customer name1 project3 com4 concultant name2 project4 I have built a filtering form. It has a textboxes for searching fo the Company and Project and checkboxes for searching for Type an Person in Charge. For example when I check customer, supplier an name2, the result should show the following in a new sheet. com2 supplier name2 project2 Any assistance is greatly appreciated. ryss -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with filtering form - newbie
Look at Advanced and Autofilter under the filter entry in the Data menu.
These can be set up and manipulated with code. Turn on the macro recorder while you do it manually to get the code. -- Regards, Tom Ogilvy "ryssa " wrote in message ... Hi there, This is my first project in excel VB and have no VB background. Hoping for some help. I have a spreadsheet with 16 fields and I have built a data entry form for it. Below is just an example of what it looks like. Company Type Person in Charge Project com1 customer name1 project1 com2 supplier name2 project2 com3 customer name1 project3 com4 concultant name2 project4 I have built a filtering form. It has a textboxes for searching for the Company and Project and checkboxes for searching for Type and Person in Charge. For example when I check customer, supplier and name2, the result should show the following in a new sheet. com2 supplier name2 project2 Any assistance is greatly appreciated. ryssa --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie trouble with polynomial trendline equation | Charts and Charting in Excel | |||
newbie trouble with formula | New Users to Excel | |||
Trouble With Data Validation And Filtering On A Dropdown | Excel Worksheet Functions | |||
Trying to make a list/form Newbie!!!!! | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |