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/DLCo...stePicture.zip
--
Regards,
Tom Ogilvy
Jase wrote in message
...
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
-----Original Message-----
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.
--
Regards,
Tom Ogilvy
Jase wrote in
message
...
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
.