Hello and good morning to all,

i have a bit of a VB question to ask, does anyone know if
there is any code that could be used on a button so it
prints the current window to a printer??

Thank you,

Robert Couchman
)

Hi Robert
why don't you use the toolbar print button for this :-)

--
Regards
Frank Kabel
Frankfurt, Germany

Robert Couchman wrote:
Hello and good morning to all,

i have a bit of a VB question to ask, does anyone know if
there is any code that could be used on a button so it
prints the current window to a printer??

Thank you,

Robert Couchman
)

What do you mean by the current window. Printout can print an object such as
the activesheet.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Robert Couchman" wrote in message
...
Hello and good morning to all,

i have a bit of a VB question to ask, does anyone know if
there is any code that could be used on a button so it
prints the current window to a printer??

Thank you,

Robert Couchman
)

Of course i would use the toolbar....

if i had a toolbar on the form! :-)

any more ideas?? there all welcome!

Thank you,

Robert Couchman
)

By current window, i mean the Form/Window that is in use!

i have a form that displays all my stats for the program,
what i would like is for a button (print) to print the
form for the user.

i know you can print the form in VB but this does not
contain the data, as this is inserted when i run the
program.

thank you,

Robert Couchman
)

Hi
try something like
worksheets("worksheetname").printout

--
Regards
Frank Kabel
Frankfurt, Germany

Robert Couchman wrote:
Of course i would use the toolbar....

if i had a toolbar on the form! :-)

any more ideas?? there all welcome!

Thank you,

Robert Couchman
)

Thank you Fran,

but im afraid its not a worksheet im trying to print!

its a form!

a userform!

although i might try "userformname".printout

doubt it working!

i will be back!

thank you,

Robert Couchman
)

Good news!!!

finaly found the answer...

"userformname".printform

thank you for all the help!

Robert Couchman
)

There wouldn't be any quotes around the name

userform1.printform

--
Regards,
Tom Ogilvy

"Robert Couchman" wrote in message
...
Good news!!!

finaly found the answer...

"userformname".printform

thank you for all the help!

Robert Couchman
)

i know but i was refering to the name of the userform!

but thanks for that anyway.

Robert Couchman
)

So was I, no quotes.

--
Regards,
Tom Ogilvy

"Robert Couchman" wrote in message
...
i know but i was refering to the name of the userform!

but thanks for that anyway.

Robert Couchman
)