>>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.

I tend to book the value into a seperate cell using Worksheet_Change() in the VBA. Then use .range("mycell").Value to collect the value.

Hope that helps ?


Gary.