Preview of Spreadsheet/Document

[Guest]

I am using Excel 97.

I am wanting to add a preview of a document in a userform. Can anyone
supply me with some code which creates the preview of a document.

Many thanks

 

[Tom Ogilvy]

See Stephen Bullens site for a technique of displaying a picture of a chart
on a userform.


http://www.oaltd.co.uk/Excel/Default.htm



you would have to do a copypicture on your range and follow a similar path.