I'm creating an Excel sheet dynamically from VB and adding an oleobject commandbutton. I've added a class module to the VB6 project.
So far so good.
I've managed to pick up some of the event from creating the workbook but whatever I do I can't pick up the button click event - I've been trying for days.
Does anyone have a simple code example or point me to a solution?
Best regards
Barry