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).
Other facts: this code is housed in the user form, NoPass.
Any help would be appreciated!
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).
Code:
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!
Last edited: