Setup ComboBox when open workbook
Hi,
I want to fill a ComboBox with items when I open the Workbook.
But I don't want to take the items from cells in the worksheet.
So I tried these lines:
Private Sub Workbook_Open()
ComboBox1.List = Array("First", "Second", "Third", "Forth")
End Sub
But this does not work.
What is missing.
Thanks in advance,
/Sören
|