Copy image of UserForm to a clipboard

[Gabor]

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 here: 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

 

[keepITcool]

Gabor..

take the rest of the day off.. no coding involved

teach ' m to use standard windows keyboard shortcuts..

[alt]+[printscreen] ...(this will dump the active form)

[alt][tab] to go to powerpoint...
[ctr][v] to paste




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

G'Day,

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

 

[Gabor]

Thanks, it's easy.
What is the code getting the [alt]+[printscreen] done by a commandbutton?
Gabor

Gabor..

take the rest of the day off.. no coding involved

teach ' m to use standard windows keyboard shortcuts..

[alt]+[printscreen] ...(this will dump the active form)

[alt][tab] to go to powerpoint...
[ctr][v] to paste




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

G'Day,

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

 

[keepITcool]

in VB6 it would be Sendkeys "%{PRTSC}"
although it doesnt generate an error in VBA..
it doesn't do anything noticable either


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

Thanks, it's easy.
What is the code getting the [alt]+[printscreen] done by a commandbutton?
Gabor

Gabor..

take the rest of the day off.. no coding involved

teach ' m to use standard windows keyboard shortcuts..

[alt]+[printscreen] ...(this will dump the active form)

[alt][tab] to go to powerpoint...
[ctr][v] to paste




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

G'Day,

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