Can't Get Drop Down List To Populate In User Form

[drmingle]

UserForm Name: "Ncb"

Objective: Make use of a drop down list within an an Excel 2007 User Form by populating with the specified item (eg Actual charages, B1, and B2).

Private Sub NoPass_Initialize()
  With Ncb
     .AddItem "Actual Charges"
     .AddItem "B1"
     .AddItem "B2"
   End With
End Sub

Other facts: this code is housed in the user form, NoPass.

Any help would be appreciated!

 

[drmingle]

I thought that even this might be the solution, but I am missing something:

Private Sub NoPass_Initialize()
    Ncb.List = Array("Actual Charges", "B1", "B2")
End Sub