Populate Column Header on ComboBox

[michael_13143]

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

 

[Juan Pablo Gonzalez]

The only way that I know to do that is to tie the combobox contents to a
range in a worksheet, and put the headers in there too. No programatical
way to do that