Solved: Dynamic Drop down list based on filtered list

[khalid79m]

I have attached a workbook, with comments.

I have a list of data which I filter , after the filter , i want my drop down in my excel form to only show the filtered data for unqiue id in the drop down. if that makes sense.

See workbook attached

[mdmackillop]

No attachment

[Simon Lloyd]

Without an attachment this, i assume is what you want:
Private Sub UserForm_initialize()
Dim Rng As Range, MyCell As Range
Set Rng = Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row)
For Each MyCell In Rng.SpecialCells(xlCellTypeVisible)
Me.ComboBox1.AddItem (MyCell)
Next
End SubThis code will add all the visible items in coulmn A.