VBA Combobox Dynamic range with criteria

[mrhonda]

Hello Gents,

I need your expertice again

I have a column (Column B) with ordernumbers like this:
W-1604
C-1605
F-1606
W-1607
F-1608
etc
etc
etc

The numbers are Unique, the letters W, C and F indicate something else.

Can you guys tell me the Code that is needed To list only the 'W' numbers in a combobox on a userform.
The list is Dynamic.

From there on I know what to do

Thanks in advance!

 

[GTO]

Overly simplified, but does this help?

Private Sub UserForm_Initialize()
Dim Cell As Range
    
    'Please note, default codename used, change to suit
    With Sheet1
        For Each Cell In Range(.Cells(2, 2), .Cells(.Rows.Count, 2).End(xlUp))
            If UCase(Left(Trim(Cell.Value), 1)) = "W" Then
                Me.ComboBox1.AddItem Trim(Cell.Value)
            End If
        Next
    End With
End Sub

 

[mrhonda]

Spot on GTO!

Thanks a lot