Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 91
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Andy Pope's button image editor; pasting icons to sheet then toolbar- why does image quality degrade? ker_01 Excel Programming 1 July 28th 08 01:57 PM
Is there any way to search image of my local drive with Image name or Image Title, Description [email protected] Excel Programming 3 August 3rd 07 01:44 PM
VBA to display image on a form - image is defined in Range Name Tan Excel Programming 4 May 17th 06 03:37 PM
Programatically control picture property of Image control Brassman[_5_] Excel Programming 5 May 24th 05 09:32 PM
Export the worksheet background image as an image file - possible? DataFreakFromUtah Excel Programming 2 April 10th 04 04:49 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"