Auto Populate Combo Box When Opening a Worksheet
 

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

Auto Populate Combo Box When Opening a Worksheet
 

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

Auto Populate Combo Box When Opening a Worksheet
 

On Jul 2, 2:08 pm, "Chip Pearson" wrote:
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 Consultingwww.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

Perfect! Thanks Chip - really appreciate the help.