VB UserDocument on Excel sheet
I've create a simple "ActiveX Document DLL" in VB6 providing a "User
Document" with a control drawing some graphics on it.
I also added a label, a button and a edit field to the document.
Inserting this into a Excel worksheet using the following piece of VBA code:
ActiveSheet.OLEObjects.Add ClassType:="DocDLL.Document"
I can see the document on my sheet, but the graphics are never drawn and
both button and edit field are just black boxes. The document won't ever get
a Resize event if resized but the initial contents get drawn as a graphics
and scaled when resized.
What I want is the document to react on resize events and a dynamic graphics
to be drawn. I'd also like to get the button click event...
Any hints for me?
Thanks,
Thomas
|