LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Copy image of UserForm to a clipboard

G'Day,

I have developed a UserForm which is now in use at my company to view
records of a database.
It is getting more and more popular, and I have to express he THANKS FOR
EVERYONE who helped me out with my hopelessly novice questions re UserForms
over the last couple of years. GREAT !!! I have learnt a great deal, without
this NG and the experts out there I would not have been able to accomplish
the task ...

Now, here is the next hurdle, at least for me: some of the guys use the
images of the UserForms in Powerpoint presentations: their problem is they
cannot easily paste the image of the UserForm on to a .ppt slide. They make
a screenshot, paste it into Paintbrush, then section that picture and copy
the required portion into the presentation slide, or .doc or whatever.
Cumbersome ! There's got to be a better way !

The question is: what would be the code run by a CommandButton on the
userform which would copy the image of the UserForm to the clipboard ? I
mean: the UserForm only, without the surrounding view of the screen.
The procedure would be: the user hits that commadbutton [image copied to
clipboard] then user switches to Powerpoint slide. Then user pastes the
image onto the powerpoint slide with Ctrl+v .

I've tried all commands, no success...
Please help...

Grazie mille


Gabor


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving clipboard image as BMP through VBA in Excel Elliot Excel Discussion (Misc queries) 0 September 17th 08 03:22 AM
copy shape image into image control Luc Benninger Excel Programming 2 July 15th 04 11:14 AM
loading a bitmap into an image control from the clipboard Loane Sharp Excel Programming 4 February 29th 04 01:49 PM
Userform Image help Pete[_13_] Excel Programming 1 November 10th 03 10:26 PM
Putting an image into the clipboard Jonathan Crow Excel Programming 2 September 12th 03 12:06 AM


All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"