View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas Baier Thomas Baier is offline
external usenet poster
 
Posts: 1
Default 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