ComboBox problem

[John]

Hi,
I'm using Excel 2003
I have a spreadsheet using a ComboBox that allows selection of one of
several sets of data. Each set is a 3 column row of data. I have the
following properties set:
BoundColumn: 2
TextColumn: 1
When a selection is made the ComboBox displays the column 1 value.
The ComboBox seems to behave normally, except that when I close and open the
file the combox displays the value of column 2 (instead of column
1). When a new selection is made it goes back to displaying the column 1
data.
Shouldn't it always display the data as assigned by TextColumn (column 1)?
How can I force it to?
Thanks,

-John

 

[Ken Snell \(MVP\)]

You've posted this question in an ACCESS newsgroup, not an EXCEL newsgroup.
I recommend that you post it in an EXCEL newsgroup.