View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?