View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Saving Userform as Gif

With Alt-Print Scrn you only capture the userform when it is active
Paste it in Paint and save it

If you want to have a program for this buy Snagit
http://www.techsmith.com/default.asp


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Amedee Van Gasse" wrote in message ...
Robert wrote:

Hi,

Anyone got any ideas on how to save a userform through VBA as a gif?
Found plenty on saving a chart as a gif, but can't figure out how to
do the same with a userform.

Thanks


I don't want to sound silly, but... how about taking a screenshot?
Using PrtSc, one of the grey keys on the top of your keyboard you
almost never use. And then you paste it in your favorite image editing
software.
Or use image editing software to take screenshots. I use Paint Shop Pro
a lot for taking screenshots of forms, because it gives me the
possibility to capture only a single screen object and not the entire
screen.

PS: I write a lot of user manuals at work, with *a lot* of screenshots
and examples.

--
Amedee Van Gasse

To top-post is human, to bottom-post and snip is sublime.