Thread: Picture
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Picture

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



.