EXCEL USING AUTOFILTER with VBA PROBLEM!!

[bakoriua]

HI

IT'S POSSIBLE TO COPY the FIELDS of an EXCEL AUTOFILTER (the dropdown list) in a combobox list??


I want to choose the field to apply to a column using a combobox of a userform:


Selection.AutoFilter field:=3,Criteria1:=Me.ComboBox1.Value

There is a way to have Combox1 list the same as filter fields list?


LET ME KNOW

 

[joerd]

You could put everything into a collection, sort the collection and then put the items of the collection into the combobox. For example:

    Me.ComboBox1.Clear
    'fill the collection from worksheet w, cells A2, A3, ...
    i = 2
    On Error Resume Next
    Do While w.Cells(i, 1).Value <> ""
        c.Add w.Cells(i, 1).Value, CStr(w.Cells(i, 1).Value)
        i = i + 1
    Loop
    'Sort the collection, if you want.
    'Insert your favorit routine here.
    
    'Add the items of the collection into the combobox
    For Each p In c
        Me.ComboBox1.AddItem p
    Next p

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.