Help with ComboBox

[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

 

[Jim]

John, Try setting your column count property to 1.

 

[John]

Jim,
Thanks,
I tried - and it still doesn't work
Also, I wanted the 3-column rows of data visible in the drop down box.
When the file is first open it displays properly for a moment then the value
changes as I described.
It must be doing some evaluation at start up.

-John

 

[Jim]

John,
I have an active X combo box directly on the worksheet and it was
acting like you describe.. I had col 1 as text col and col2 as bound,
but sometimes i would open the
workbook and col 2 displayed in the box. I tried forcing down the
ColumnCount to 1.
I continued getting box displaying a blank when opened the workbook.
Since then, I have increased the ColumnCount to 2. I set the Column
Widths to 75,0,
and it seems to have stopped.

As you want all 3 columns to show in the dropdown, I would suggest
ColumnCount 3
and set ColumnWidths for each column and see if that helps.

Jim