ComboBox and AutoFilters

[deepheat101]

Hello Again,

Just a quickie...

How do you populate a ComboBox (on a UserForm) with the results from an AutoFilter'd list? I've been working around using "EntireRow.Hidden = True", but (1) I'm not certain of the syntax and (2) I'm not entirely sure if it's the right thing to use.

Many Thanks

 

[MrHaggis]

If anyone has an answer to this, it might also solve the problem I posted earlier today regarding combo box input critera. Help please!!

 

[deepheat101]

Hmmm...

Having spent the weekend pondering over this problem, I am still none-the-wiser...

I only need a pointer in the right direction.

Any help is much appreciated

 

[deepheat101]

Sometimes, just sometimes, I need to stop thinking that that Excel VB has to be complicated to work...

Private Sub UserForm_Initialize()

    LastRow = Range("F" & Rows.Count).End(xlUp).Row - 1
    
    For Each c In Range("F2:F" & LastRow)
    
        If c.EntireRow.Hidden = False Then
        
           ComboBox1.AddItem c.Value
        
        End If
        
    Next c

End Sub