ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   resizing an image on a form (https://www.excelbanter.com/excel-programming/282601-resizing-image-form.html)

Liam[_2_]

resizing an image on a form
 
I want to insert an image on a user form, but it is
larger than the area I want to use. When I resize the
object, it crops the picture instead of shrinking it.
How do I resize it instead of cropping it?

Tom Ogilvy

resizing an image on a form
 
Look at the PictureSizeMode property:

Here are the choices:

fmPictureSizeModeClip 0 Crops any part of the picture that is larger than the form or page (default).
fmPictureSizeModeStretch 1 Stretches the picture to fill the form or page. This setting distorts the picture in either the horizontal or vertical direction.
fmPictureSizeModeZoom 3 Enlarges the picture, but does not distort the picture in either the horizontal or vertical direction.



--
Regards,
Tom Ogilvy


"Liam" wrote in message ...
I want to insert an image on a user form, but it is
larger than the area I want to use. When I resize the
object, it crops the picture instead of shrinking it.
How do I resize it instead of cropping it?



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

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