Picture

[Jase]

Hi All

I have a workbook where I have added a toolbar. Now on
that toolbar I have used the standard numbered pictures,
such as picture number 52 is a piggy bank. I was
wondering if anyone know weather it is possible to import
these button pictures as actual pictures into my program?

Thanks
Jase

 

[Tom Ogilvy]

The won't be very big.

go to tools=>Customize

leave the dialog up and select one of the buttons on the menus, then right
click on it and select copy picture

close the dialog and then select the worksheet, do edit=>Paste

If you mean bring a picture in to use, reverse this. Get the image in the
clipboard, then tools=>customize, then right click on a button with the
dialog still visible and select paste picture.

In code do this with copyface and pasteface.

 

[Jase]

Thanks heaps for that Tom, I have managed to get this
into an Excel spreadsheet as images, but is it going to be
possible to move them onto a user form?

Thanks in advance
Jase

 

[Tom Ogilvy]

Manually, you can copy them to the clipboard, then go to the vbe and go to
the properties window of a control on the userform, such as a commandbutton
or image control, click in picture property space and do ctrl+v.

If you want to do this in code, I think you would need to go to Stephen
Bullen's site and look at his

pastepicture.zip

http://www.bmsltd.co.uk/Excel/Default.htm

http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=PastePicture.zip