Hi,

I got a spreadsheet with comboboxs connected to a database. Each combobox
basically load two columns of data: One for displying to user, another to be
store in database. However, everytime I save the spreadsheet, and load it up
again (when I can't finish the work), the Text property get changed to the
value in Value Property. WHY? Is there way to prevent this?
Running Win2000 & Office2003.

Thanks

for an activeX combobox, the value and text properties are identical. they
should always produce the same output.

--
Regards,
Tom Ogilvy

"augustus" wrote in message
...
Hi,

I got a spreadsheet with comboboxs connected to a database. Each combobox
basically load two columns of data: One for displying to user, another to
be
store in database. However, everytime I save the spreadsheet, and load it
up
again (when I can't finish the work), the Text property get changed to the
value in Value Property. WHY? Is there way to prevent this?
Running Win2000 & Office2003.

Thanks

Tom,
But why is it that we can specify them with different value initially?
Example,

Sheet1.cbxStructType.Clear
Sheet1.cbxStructType.BoundColumn = 1
Sheet1.cbxStructType.ColumnCount = 2
Sheet1.cbxStructType.ColumnWidths = "0;30"
Sheet1.cbxStructType.TextColumn = 2

Do While Not RS.EOF
Sheet1.cbxStructType.AddItem RS.Fields("StructID").Value
Sheet1.cbxStructType.List(Sheet1.cbxStructType.Lis tCount - 1, 1) =
RS.Fields("StructDescrip").Value
RS.MoveNext

Say Row 1, Column 1 = Me, and Column 2 = You
This will give me Value=Me, and Text=You

Even after I save the file, this will remain the same (I checked under
Design mode). However, the moment I close and reopen this book again, the
Text will change to Value.

Regards
Augustus

"Tom Ogilvy" wrote:

for an activeX combobox, the value and text properties are identical. they
should always produce the same output.

--
Regards,
Tom Ogilvy

"augustus" wrote in message
...
Hi,

I got a spreadsheet with comboboxs connected to a database. Each combobox
basically load two columns of data: One for displying to user, another to
be
store in database. However, everytime I save the spreadsheet, and load it
up
again (when I can't finish the work), the Text property get changed to the
value in Value Property. WHY? Is there way to prevent this?
Running Win2000 & Office2003.

Thanks