hi all,

i have created a format of an application form in an MS Excel spreadsheet. In some rows on this spreadsheet, i have placed a combo-box from which the user can select from a pre-determined list of items. The item list and its corresponding codes are defined with the help of the "Format Control" comand on right-clicking the combobox and specifying the "Input Range" and the "Cell Link" values. once the user selects an item and saves the spreadsheet, i would like to - through vfp6.0 code - be able to store the value (and its code seperately) of the combobox (which is in an excel spreadsheet) to variables in my vfp6.0 program.

hope the above can be understood.

with sincere thanks in advance.