ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Image Property (https://www.excelbanter.com/excel-programming/416836-image-property.html)

kirkm[_7_]

Image Property
 

Once an image is assigned to a Form, it sticks, and properties
call it Picture (Bitmap). If you want to change this a Browse
dialog appears.

But what if you, programicably, wanted to change the Picture
to another one, already embedded in another form ? i.e. a
'Pictue bank'.

Can you copy *that* image in - so Picture (Bitmap) now
references it instead?

Thanks - Kirk

Rick Rothstein

Image Property
 
Select the Image control whose bitmap you want to copy; then select the
actual wording, the (Bitmap) word with its parentheses, from the Picture
property and copy it to the Clipboard (either Ctrl+C or Edit/Copy from the
menu bar); now select the second Image control and do one of two things
depending on what you want...

1) If you want the original picture in its original size, just select the
now active Image control's Picture property and paste the Clipboard's
contents to it (either Ctrl+V or Edit/Paste from the menu bar).

2) If you have cropped the image in anyway and you want to preserve that
cropping in the second Image control, select the word (None), with its
surround parentheses, from its Picture property and then paste the
Clipboard's contents to it (again, either Ctrl+V or Edit/Paste from the menu
bar).

--
Rick (MVP - Excel)


"kirkm" wrote in message
...

Once an image is assigned to a Form, it sticks, and properties
call it Picture (Bitmap). If you want to change this a Browse
dialog appears.

But what if you, programicably, wanted to change the Picture
to another one, already embedded in another form ? i.e. a
'Pictue bank'.

Can you copy *that* image in - so Picture (Bitmap) now
references it instead?

Thanks - Kirk



NOPIK

Image Property
 
On Sep 10, 8:25*pm, kirkm wrote:
Once an image is assigned to a Form, it sticks, and properties
call it Picture *(Bitmap). If you want to change this a Browse
dialog appears.

But what if *you, programicably, wanted to change the Picture
to another one, already embedded in another form ? i.e. a
'Pictue bank'.

Can you copy *that* image in - so Picture *(Bitmap) now
references it instead?

Thanks - Kirk


you can copy reference to any object with SET

SET MyForm.Picture = AnotherForm.Picture


All times are GMT +1. The time now is 05:04 PM.

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