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

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/