J
John Ziavras
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 initially 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
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 initially 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