Set Rowsource Propety- Excel (1 Viewer)

[vjmehra]

Hi,

I am trying to set the rowsource property of a combobox by vba code. That in itself is simple enough, however I want the range covered to be all of column a (apart from row 1) and all of column b (apart from row 1) and I can't seem to work out the syntax. Is there a way to do this?

Thanks,

Vidal

 

[Pat Hartman]

This is an Access forum. You will probably have better luck posting in an Excel forum. VBA isn't VBA when it comes to the object models. The syntax will be different especially since relational tables are not referenced by row/column.

 

[vjmehra]

Not to worry anyway, I was just being stupid. Solved it now.