Combobox in Excel

[henpat]

Hello all
How can I fill the Combobox when a sheet is open in Excel 2003?

Thanks a lot.
henpat

 

[Chip Pearson]

Try code similar to the following in the ThisWorkbook code
module:

Private Sub Workbook_Open()
With Worksheets(1).ComboBox1
.AddItem "A"
.AddItem "B"
' etc
End With
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[henpat]

thanks

Try code similar to the following in the ThisWorkbook code module:

Private Sub Workbook_Open()
With Worksheets(1).ComboBox1
.AddItem "A"
.AddItem "B"
' etc
End With
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com