Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Additem to ComboBox using the Column Property
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Additem to ComboBox using the Column Property
ComboBox1.AddItem .Fields(0).Value
ComboBox1.List(ComboBox1.ListCount - 1, 1) = .Fields(1).Value vqthomf wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Additem to ComboBox using the Column Property
Thanks I should of tried something like that because it's just like using the
listview regards Charles "JW" wrote: ComboBox1.AddItem .Fields(0).Value ComboBox1.List(ComboBox1.ListCount - 1, 1) = .Fields(1).Value vqthomf wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
additem to combobox with an array | Excel Discussion (Misc queries) | |||
combobox additem | Excel Programming | |||
AddItem Method - Combobox value | Excel Programming | |||
additem to a combobox from other excel worksheet | Excel Programming | |||
Multiple Column ComboBox using Additem | Excel Programming |