Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default PictureBox control in VBA Excel form?

Hi there,

I need to do some image and drawing functions - scale down an image
loaded from a PNG file, setting the white colour as transparent, adding
another file on the bottom of the first file etc.

Now I think the VBA "Image" control has not enough functions to do
that... how can I do these complex operations in VBA? Should I import a
PictureBox control?



Thanks in advance,

Thomas
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,236
Default PictureBox control in VBA Excel form?

There *are* ways, although the one's I know about involve hitting the API.

gdiplus comes standard with Windows XP and is available as a download for
other OS. It's a library with lots of imaging functions. I believe scaling
is one of them.

I have an example of cropping on my website (Charting), but no scaling.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Thomas Wieser" <wernze.nospam@gmx_net wrote in message
y.telekom.at...
Hi there,

I need to do some image and drawing functions - scale down an image
loaded from a PNG file, setting the white colour as transparent, adding
another file on the bottom of the first file etc.

Now I think the VBA "Image" control has not enough functions to do
that... how can I do these complex operations in VBA? Should I import a
PictureBox control?



Thanks in advance,

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
2007 Form Control/ActiveX Control font difference Nikko963 Excel Discussion (Misc queries) 0 April 15th 09 04:21 PM
Drop Down Form control always causes excel to crash headly Excel Discussion (Misc queries) 1 June 22nd 06 03:38 AM
how to delete or remove checkbox form control in Excel? tubbekans Excel Discussion (Misc queries) 1 December 14th 05 08:51 PM
How do I insert a PictureBox into Excel? Evanbron Excel Discussion (Misc queries) 3 October 25th 05 02:16 AM
passing control value from one form to another form mark kubicki Excel Programming 1 April 3rd 04 01:27 AM


All times are GMT +1. The time now is 06:55 PM.

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

About Us

"It's about Microsoft Excel"