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

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)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

On Jul 2, 2:08 pm, "Chip Pearson" <c...@cpearson.com> 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)
>
> <spovo...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
> > 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.