ComboBox Population: Excel

[Funkymatt]

I'm running into errors with the following EXCEL worksheet.

Sheet1.cboCollatType.Add ("PC&quot
Sheet1.cboCollatType.Add ("REMIC&quot
Sheet1.cboCollatType.Add ("BALLOON&quot

I also tried the AddItem method.

 

[vb6novice]

Isn't the method to add a combo box item ".AddItem", not ".Add" ?

 

[Funkymatt]

I tired the dot AddItem as well. I think that my problem is I need to populate the "Sheet1" ComboBox1 when the XLS is opened for the first time. I think that my Sheet1 object isn't valid and that is the reason the AddItem method isn't working.

Private Sub Workbook_Open()

Worksheets("sheet1&quot.Activate
??Worksheets("sheet1&quot.cboCollatType.AddItem ("PC&quot
Sheet1.cboCollatType.AddItem ("REMIC&quot
Sheet1.cboCollatType.AddItem ("BALLOON&quot

End Sub

Yikes....I have no idea what I'm doing. OR...can I pre-populate these items using the properties at design time.