Very visual basic

[Robert Couchman]

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
([email protected])

 

[Frank Kabel]

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

 

[Bob Phillips]

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]

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
([email protected])

 

[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
([email protected])

 

[Frank Kabel]

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

 

[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
([email protected])

 

[Robert Couchman]

Good news!!!

finaly found the answer...

"userformname".printform

thank you for all the help!

Robert Couchman
([email protected])

 

[Tom Ogilvy]

There wouldn't be any quotes around the name

userform1.printform

 

[Robert Couchman]

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

but thanks for that anyway.

Robert Couchman
([email protected])

 

[Tom Ogilvy]

So was I, no quotes.