Excel: combo box.

I googled but couldn't find an answer. I'm still pretty new to VBA. And I want to use a combo box / list box to show the items in a column which I can select. For example: [HTML] A 1 apple 2 orange 3 apple 4 banana [/HTML] I want the combo box / list box to show the list of items in column A. And say, I select orange on the combo box / list box then I want to use the selected data for filtering. All suggestions and ideas are welcomed. Thanks in advance.

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of May 29, 2014.

For more resources for Microsoft Excel