I want to populate a combobox with 10 integers using VBA. I also wan
the word "Integers" to display as teh field name in the column hea
part of the drop down list.

Here is the code for the list of integers.

Sub Add_Combobox_Items()
For x = 1 To 10
Sheets(1).ComboBox1.AddItem x
Next
End Sub

How do I get the word "Integers" in the column heading? Unde
Combobox1, Properties, Columnheads is set to True

--
Message posted from http://www.ExcelForum.com