Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement