Newbie question: populating combobox

[WiLey2000]

Hi all,

Is it possible to populate a combobox from a table column?
If so, could someone give me an example.

Thanks
WiLey2000

 

[specci48]

Hi WiLey2000,

it is possible, but you have to cycle through all rows of the table. There is no "standard"-function for that:

Sub FillComboFromTable
   For i = 0 To Table1.RowCount - 1
      ComboBox1.Add(Table1.Cell("ComboColumn", i))
   Next
End Sub

specci48

 

[WiLey2000]

thanks specci48 I should of known that!

WiLey2000