Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create Login & Log out Spread sheet in Excel with automated Attendance sheet | Excel Worksheet Functions | |||
Split text file into Excel sheet and separate the final results intoa new sheet | Excel Worksheet Functions | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |