Hi,

Im very new to excel vba. I have created a combobox from the control toolbox and have tried to populate it using the following code:

Private Sub workbook_open()

With ComboActions
.Clear
.AddItem "<Select Action>"
.AddItem "Sort by Status, Resolve Date, Score"
.AddItem "Extract Priority Risks"
.AddItem "View Business Risks"
.AddItem "View Technical Risks"
.AddItem "View All Risks"
End With

End Sub
which resides in the a worksheet object. The problem is that whenever i open the workbook, the items are no longer filled in the combobox.

Can anyone point out what im doing wrong? Thanks in advance!