Thread: Additem to ComboBox using the Column Property
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
  
Posts: 638
Default 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

Reply With QuoteReply With Quote