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

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

--
Regards,

Juan Pablo González

"michael_13143 " wrote in
message ...
I want to populate a combobox with 10 integers using VBA. I also want
the word "Integers" to display as teh field name in the column head
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? Under
Combobox1, Properties, Columnheads is set to True.


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