Excel VBA: Filter Results using Textbox

0
votes

I am using Excel 2010 and I want to get data input from a user typing into a TextBox or ComboBox. I am assuming that you can only use the ActiveX Controls for this.

When I get the data, I want to match it against my results such that it only displays data matching the input of the Text/Combo Box.

Is there an example or a quick way to perform this?

1
excelvbacomboboxfiltertextbox

1 Answers

0
votes

I think you should look into Pivot Tables [http://en.wikipedia.org/wiki/Pivot_table]. Also [http://www.addictivetips.com/microsoft-office/excel-2010-create-pivot-table-chart/]