userForm listBox being double-loaded

Any ideas?

Probably, once you post your workbook with the code.

Here's the concerned code:

Private Sub selectCedarHill_Click()
    Dim cName As Range
    Dim cID As Range
    Dim ws As Worksheet
    Set ws = Worksheets("lookupData")
    Me.txtDate.Value = Format(Date, "ddd, m/d/yyyy")
    Me.selectCedarHill.Value = True
    Me.selectDeSoto.Value = False
    Me.selectLancaster.Value = False
    Me.lbSelectDriver.RowSource = ""
    For Each cName In ws.Range("cedarHillDriverList")
        With Me.lbSelectDriver
            .AddItem cName.Value
        End With
    Next cName
End Sub

Here's then initialize section:

Private Sub userForm_initialize()
    Call selectCedarHill_Click
End Sub

The data is in the "lookupData" sheet, within the "cedarHillDriverList" range. The range is defined by:

=OFFSET(lookupData!$BD$2,0,0,COUNTA(lookupData!$BD:$BD)-1,1)

It appears to be working correctly as well.

Any ideas now?

Bob

Isn't the critical point about how to empty the list. Something like
"Me.lbSelectDriver.removeAll".

How can I accomplish that sort of thing?

Thanks.

Ok - i'm always up for "easy".

BTW - "DNR"?

Bob

DNR = dynamic named range.
Got lazy . . . . . . with typing.

Worked like a champ. Thanks for your help.

Bob