Excel - Additem to ComboBox using the Column Property

Asked By vqthom on 28-Sep-07 12:10 PM
Hi I have been trying to add to a combobox column using
ComboBox1.Column(0)=.Fields(0).value
ComboBox1.Column(1)=.Fields(1).value
but I keep geting an error can someone please point in the right direction.
TIA
Charles




JW replied on 28-Sep-07 12:47 PM
ComboBox1.AddItem .Fields(0).Value
ComboBox1.List(ComboBox1.ListCount - 1, 1) = .Fields(1).Value
vqthom replied on 28-Sep-07 01:18 PM
Thanks I should of tried something like that because it is just like using the
listview
regards
Charles