Putting an image into the clipboard

  • Thread starter Thread starter Jonathan Crow
  • Start date Start date
J

Jonathan Crow

i am trying to create a custom icon for a custom control
button. I have gone through all of the knowledgebase
articles about how to do this and have copied the code
into my module but I always get to the part where it tell
me to put the image into the clipboard by using the
Clipboard.SetData command. Well, it never works, I have
tried:

Dim MyIcon as StdPicture
Set MyIcon = LoadPicture("C:\someiconfile")
Clipboard.SetData MyIcon

the LoadPicture seems to work but when I get to the
Clipboard line it tells me "Object Required". I have tried
all of the variations I can think of
Cliboard.SetData MyIcon, 2
MyIcon.PutInClipboard

Nothing seems to work. Any ideas?

From there I think it will be pretty easy to do a
PasteFace onto the control button.

thanks,
jonathan
 
Jonathan,

I load the pictures onto a hidden worksheet, and then just use the PasteFace
method to get them by name. Far easier than all that you are going through.
 
Turn on the macro recorder while you do Insert=>Picture in the menu to get
your picture on the worksheet. Then select the picture and do Edit=>Copy.
That gets it on the clipboard. Now you can do customize, select the button
and do PasteFace. Turn off the macro recorder.

Just to add a little more detail.
 
Back
Top