Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting an image into the clipboard
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting an image into the clipboard
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. -- HTH Bob Phillips "Jonathan Crow" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting an image into the clipboard
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. -- Regards, Tom Ogilvy Bob Phillips wrote in message ... 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. -- HTH Bob Phillips "Jonathan Crow" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? | Setting up and Configuration of Excel | |||
Saving clipboard image as BMP through VBA in Excel | Excel Discussion (Misc queries) | |||
Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
Hyperlink to an image in other worksheet, displaying entire image. | Excel Worksheet Functions | |||
Need to turn off prompt about putting on clipboard or not... | Excel Discussion (Misc queries) |