Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Save VB Userform Frame1 as Image?

Hello fellow programmers!

I am in need of some code to get VB to understand that it is suppose
to save the contents of whatever is in UserForm1 Frame1 as an image
(*.jpg)...I've seen this done with charts & graphs but was wondering
if this is possible with frames? Any help is much appreciated! Thanks!

-Todd

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Save VB Userform Frame1 as Image?

Todd,
The easy way is to use Windows functionality of pressing ALT+PRINTSCREEN,
than paste into a graphics app.

Otherwise, as most of the controls on a VBA userform are windowless (they do
not have a handle, HWnd), I would imagine you have get the coordination of
the frame, translate them to pixels and using the Hwnd of the underlying
form call some API functions.
Then save the resulting memory DC as a bmp or jpg.
Doable, but not simple.

NickHK

wrote in message
ups.com...
Hello fellow programmers!

I am in need of some code to get VB to understand that it is suppose
to save the contents of whatever is in UserForm1 Frame1 as an image
(*.jpg)...I've seen this done with charts & graphs but was wondering
if this is possible with frames? Any help is much appreciated! Thanks!

-Todd



Reply
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
save userform as image Tom Ogilvy Excel Programming 1 December 9th 06 01:41 AM
Print Frame1 Abdul[_2_] Excel Programming 0 October 15th 06 01:33 PM
best image on a userform obsessive Excel Programming 0 May 4th 06 10:25 PM
Userform Image Jennifer Excel Programming 10 February 24th 06 07:44 PM
Userform Image help Pete[_13_] Excel Programming 1 November 10th 03 10:26 PM


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

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

About Us

"It's about Microsoft Excel"