maybe this...

check out these properties of a combo:
..ColumnCount = 'int value
..BoundColumn = 'int value



Hi,

I have an Access database with a form that has an entry with a drop down
list attached to it. The list has two columns in it. When you select one
of the options from the list it populates one field with the first column
and another field with the second.

Is there a way in Excel to do the same thing?

I have the two columns set up as a range already, but can't get it to
work.

Any suggestions?

Thanks

Keith