How to use filter in Excel 2007?

**sunny17** · 06-27-2011, 06:43 AM

How do I use Filter in Excel 2007, when I'm using combo boxes for selecting a value in a data cell of a column?

**pblnrao** · 06-27-2011, 07:02 AM

Can u attach a sample excel file for clarity...?

**Azam Ali** · 06-27-2011, 07:21 AM

Hi sunny17

Kindly look the enclosed file that may be helpfull or upload a sample wookbook.

**sunny17** · 06-27-2011, 07:27 AM

Hello,
I've attached the excel sheet. Please look into it.

Regards,
Sunny

**Azam Ali** · 06-28-2011, 07:31 AM

Dear sunny17

Use ActiveX Contorls instead of Form Contorls to make a combo box. For this purpose, from the contorls on developer tab:

Select the combo box from ActiveX Contorls and draw in a cell.
Right click on it an in properties enter the cell reference in "Linked Cell" & List Fill Range".
Close properties & click on design mode to make in inactive.

Click on the Design Mode to edit the combo box.

i use an example in the Cell D3 of the enclsoed file that may be help full

the following link could be more helpfull

http://www.contextures.com/excelfiles.html#DataVal