hi,

I'm using ADO to populate a combobox, but everytimes I saved this workbook,
the data in the combobox would disappear, and the only thing remain is the
value selected. Is there way so that the records remain in the combobox,
beside loading the data to a sheet, then put a reference to ListFillRange? OR
loading the data again?
Also, with the above case, the BoundColumn and TextColumn reference to
different data Column in ADO (TextCOlumn reference to human-text, adn
BoundColumn reference to some obscure stock-code), but everytimes when I open
a saved workbook, the Value Property will over-write the Text Property. i
thought Value and Text Properties could be reference to different value?

Thanks
Augustus