I would like to populate a listbox with two columns based on two named ranges...
was playing a little bit, but it's not working as I hoped...

Any ideas?

here's what i got so far:

Private Sub optpurchaserlist_Click()
    If Me.optpurchaserlist.Value = True Then
       With usrsettings.listaccount
        .Columns.Count(1).RowSource = "purchaser"
        .Column.Count(2).RowSource = "purchaser_email"
        .BoundColumn = 1
        .ColumnHeads = False
        .ColumnCount = 2
    End With
    End If
End Sub