Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Andy Pope's button image editor; pasting icons to sheet then toolbar- why does image quality degrade? | Excel Programming | |||
Is there any way to search image of my local drive with Image name or Image Title, Description | Excel Programming | |||
VBA to display image on a form - image is defined in Range Name | Excel Programming | |||
Programatically control picture property of Image control | Excel Programming | |||
Export the worksheet background image as an image file - possible? | Excel Programming |