Hi,

I am a kinda of newbie with VBA and I am working on a macro that would
allow the user to easely filter a huge sheet called "Data". The sheet
data has a variable number of rows and columns and have headers.I am
working with excel 2000 and with userforms.

Part of what I would like to do is:
- in combobox1 the user can choose among the headers of the sheet.
- when he chooses one, the unique value of the columns content is
displayed in listbox1

Example :
Data :
A B C D
1 f 33 t
2 f 34 t
1 g 33 t
2 g 35 u

So combobox1 would display : A, B, C, D

And if the user clicks on A,
listbox1 would display : 1,2
If he clicks on C,
listbox1 displays : 33,34,35

Any ideas?

Vincent
Philadelphia