prinitng userform

[shiftyspina]

Hi

I hope someone could help me please?

I have a sheet which has a userform pop up when the sheet opens, it basically gives a description/summary of the figures in the sheet and has formulas in it to summarise the data.

What i need to be able to do is print this along with the workbook, is this possible to do? if so how do you do it without actually going into the userform in the developer tab and printing it there?

Thanks

Dan

[Norie]

Dan

You could use Me.PrintForm in the userform module.

Mind you in the past I've been kind of disappointed with the result when using that method.

What I usually do is transfer the data to a (temporary?) worksheet, format/page setup etc and then print the sheet.

[shiftyspina]

not to worry

i managed to do it by adding a command button on the form then using the code

in the commandbutton_click section of the coding

[shiftyspina]

it doesnt come out how i want it to, it comes out like it does if i was to print it from the vba editor, but my directopr seems to be happy enough with it looking like that, i just needed him to be able to print it without explaining how to go into the vba then printing it

thank you Norie