J
Jason Gatsby
Hi - I would try the RowSource property using the syntax
you had suggested previously (viz., sheet1!A1:C5 -> This
would give you 3 columns of data available to the combo
control. Then just set ColumnCount, ColoumnHeads,
ColoumnWidth, etc). I would do this manually right on the
property sheet for the control in design mode.
For simple values, I would use a For loop or:
cbo.AddItem "1"
cbo.AddItem "2"
cbo.AddItem "3"
cbo.AddItem "4"
hth -jg
you had suggested previously (viz., sheet1!A1:C5 -> This
would give you 3 columns of data available to the combo
control. Then just set ColumnCount, ColoumnHeads,
ColoumnWidth, etc). I would do this manually right on the
property sheet for the control in design mode.
For simple values, I would use a For loop or:
cbo.AddItem "1"
cbo.AddItem "2"
cbo.AddItem "3"
cbo.AddItem "4"
hth -jg