ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VB UserDocument on Excel sheet (https://www.excelbanter.com/excel-programming/310903-vbulletin-userdocument-excel-sheet.html)

Thomas Baier

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




All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com