I am developing a spreadsheet to be used by payroll clerks to enter
time for field technicians. I perform some calculations on the
employees entered and then create 2 sheets within the workbook -- one
containing the data for technicians, and the other containing the data
for hourly workers. I do the split based on whether the employee has a

tech number. Once the 2 sheets are created, I then create a CSV file
for each sheet. I want to post a message box at the end of the
calculations to indicate the number of records created. Is there a way

to post a message box that the user can print or is there a better way
to display the information so the user can print it? Thanks!

Connie

Put it out to a userform, and add a print button on the userform.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Connie" wrote in message
oups.com...
I am developing a spreadsheet to be used by payroll clerks to enter
time for field technicians. I perform some calculations on the
employees entered and then create 2 sheets within the workbook -- one
containing the data for technicians, and the other containing the data
for hourly workers. I do the split based on whether the employee has a

tech number. Once the 2 sheets are created, I then create a CSV file
for each sheet. I want to post a message box at the end of the
calculations to indicate the number of records created. Is there a way

to post a message box that the user can print or is there a better way
to display the information so the user can print it? Thanks!

Connie