Printing Userforms in excel

[Lost4Words]

I'm trying to print out an excel userform which contains an image control. The image control is loaded with a graph picture (GIF) using the following code: UserForm6.Image1.Picture = LoadPicture(fname). The form also contains several text boxes. I also have a command button setup to print out the userform, which it does partially, the graph image unfortunatley is not being printed just the image1 window itself. Any ideas?

 

[NdNoviceHlp]

cntrl+alt+printscreen will copy the visible userform. Paste to a Word doc and print. HTH. Dave

 

[Lost4Words]

Many thanks, works a treat. Is there anyway to automate this method, vba code would be rather lovely, click a button and hey presto...?

 

[NdNoviceHlp]

Perhaps using sendkeys to emulate the cntrl+alt+printscreen would work? Dave