Hey Guys, I need some help:
I have a frame on userform, I load a picture in this frame, and some labels over this picture. Its working great, but I need to export the entire frame (with pictures and labels) as Image, like jpeg... Is there way to do that?
PictureBox on vb6 may do this work, putting texts over the image and print them, but in excel there some way ?
Thanks
Welcome to the forum
One way:
{CTRL] {Print Screen} will grab screen image
Paste with {CTRL} V into Microsoft Paint or similar
Crop the image
Save image
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hi, thanks!
This way I already do, but I need to do this via VBA, because I need to insert this image in a worksheet to print.
Thanks!
Give this a try... put the code below in a module, and then call CaptureAndPaste from your code to capture the form and paste it, change range as needed.
This basically executes an Alt-PrintScreen and then pastes into a range. (It will however, capture the whole form (active window actually), but I assume the form will be active).
Please Login or Register to view this content.
Last edited by Arkadi; 09-20-2017 at 03:46 PM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Hi, it worked great, its take a print screen from active form, but I need to take a print of only one frame inserted in this userform...
Thanks!!!!
Ok... here is a more complex attempt...
Wherever you need it in the userform code, paste this (adjust the Frame1 to the name of the frame):
And this in a module somewhere:Please Login or Register to view this content.
Others may have a more sophisticated approach, but this is the best I could do.Please Login or Register to view this content.
Last edited by Arkadi; 09-21-2017 at 12:18 PM.
Hi, thank you so much, it worked!
If I understood, the sub make a ALT + PRTSCN on Userform, then paste to sheet, and crop the image on worksheet, is that?
It will be possible instead pasting to a sheet, but exporting as JPEG?
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks