Hello again,

Below is a snipit of my code that actually works shock, horror. The problem is I would like to qualify the combobox range further somehow. I only want it to show items in the list that
1. are in the Range
2. do not have a value in column "E"

Any assistance would be greatly appreciated 

Private Sub UserForm_Initialize()
Dim myRng, myRng2 As Range
Dim groupCB, numofpeople, numofgroup As String
Dim ws As Worksheet
Dim iRow As Long
Set ws = Workbooks("sum workbook").Worksheets("sum details")

If ws.Cells(3, 1) = "" Then
Me.groupCB.Value = ws.Cells(2, 1)
Else
With ws
    Set myRng = .Range("A2", .Cells(.Rows.Count, "A").End(xlUp))
    Me.groupCB.List = myRng.Value
End With
End If
If ws.Cells(3, 3) = "" Then
Me.numofpeople = ws.Cells(2, 3)
Else
With ws
Set myRng2 = .Range("c2", .Cells(.Rows.Count, "C").End(xlUp))
Me.numofpeople.Value = Sum.myRng2
End With
End If