Delerna
No, what I mean is that I have a button on the spreadsheet and when I click it, i want it to execute VB code back in my application, not in the spreadsheet.
I don’t necessarily have to pass a particular parameter, I am wanting the button on the spreadsheet to act as a trigger for more output to be produced.
For example, on my application you click, say, ‘Print Report’ which gives you summary info, then you click the ‘More Detail’ button on the spreadsheet to then execute more code which returns more detail on the spreadsheet! The user might not want all the detail all of the time!
I'm thinking either that I could set up an ODBC connection and use Let's or something along those lines?!?!
Thanks for your help!