Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create Login & Log out Spread sheet in Excel with automated Attendance sheet marc5354 Excel Worksheet Functions 2 September 21st 10 04:22 PM
Split text file into Excel sheet and separate the final results intoa new sheet Luciano Paulino da Silva Excel Worksheet Functions 8 April 18th 09 02:00 AM
excel sheet bootom half sheet goes behind top part of sheet rob Excel Worksheet Functions 2 January 17th 09 01:28 AM
Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X tempjones Excel Programming 2 June 7th 04 09:48 PM
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet arunjoshi[_5_] Excel Programming 1 May 2nd 04 03:50 PM


All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"