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:
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.
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
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.