Try something like the following. It MUST be in the ThisWorkbook code
module:

Private Sub Workbook_Open()
With Me.Worksheets("Sheet1").ComboBox1
.AddItem "Cindy"
.AddItem "Kathy"
.AddItem "Sandy"
.ListIndex = 0
End With
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


wrote in message
ups.com...
Somebody PLEASE help me figure out how to autopopulate a combobox (the
control, not form) when opening an Excel sheet.

I literally just want to fill the cboBox with a set of text values
automatically when opening the document. This should be simple,
right??? Thanks,
Steve