Need a simple printing macro code
 

I have this userform that refers to Sheet1 (in Sheet1 I have data comin
from Texbox's at the userform). I have a button at the userform that
want to use to print whatever I have in Sheet1 (I have already set th
print area in Sheet1).
I have looked at samples but something is wrong.
Can anyone help me with a simple code to print a page?
Thank you very much.



--
cene
-----------------------------------------------------------------------
cenee's Profile: http://www.excelforum.com/member.php...fo&userid=3565
View this thread: http://www.excelforum.com/showthread.php?threadid=55438

Need a simple printing macro code
 

Hi Cenee,

I have looked at samples but something is wrong.

What have you tried and what problems have you encountered?

Perhaps, however, try:

Sheets("Sheet1").PrintOut


---
Regards,
Norman


"cenee" wrote in message
...

I have this userform that refers to Sheet1 (in Sheet1 I have data coming
from Texbox's at the userform). I have a button at the userform that I
want to use to print whatever I have in Sheet1 (I have already set the
print area in Sheet1).
I have looked at samples but something is wrong.
Can anyone help me with a simple code to print a page?
Thank you very much.

M


--
cenee
------------------------------------------------------------------------
cenee's Profile:
http://www.excelforum.com/member.php...o&userid=35654
View this thread: http://www.excelforum.com/showthread...hreadid=554384