View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sören_Marodören Sören_Marodören is offline
external usenet poster
 
Posts: 18
Default 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