ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PictureBox control in VBA Excel form? (https://www.excelbanter.com/excel-programming/294720-picturebox-control-vba-excel-form.html)

Thomas Wieser

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

Rob van Gelder[_4_]

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





All times are GMT +1. The time now is 12:29 PM.

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