Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pre-numbered tickets
I have a form created in excel we use to write up work orders. I have now
been asked to keep blank copies (about a hundred at a time) that are pre-numbered. Of course, I don't want to change the number, print, change the number, print etc, a hundred times to get all those blanks. Do you know how I can do this easily? any help would be appreciated. Jenni |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pre-numbered tickets
Hi Jenni
Maybe http://www.rondebruin.nl/print.htm#number -- Regards Ron de Bruin http://www.rondebruin.nl "Ripple919" wrote in message ... I have a form created in excel we use to write up work orders. I have now been asked to keep blank copies (about a hundred at a time) that are pre-numbered. Of course, I don't want to change the number, print, change the number, print etc, a hundred times to get all those blanks. Do you know how I can do this easily? any help would be appreciated. Jenni |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pre-numbered tickets
Here is some code for you. You need to put it into a module and attach a
button to it. It increments the number in cell E1 on "Sheet1" by 1 and then prints a copy. It allows you to print a variable number of copies base on an input. Public Sub PrintCopies() Dim intNumberOfCopies As Integer Dim intCounter As Integer intNumberOfCopies = InputBox("Please enter the number of copes to print.", "Copies", 100) For intCounter = 1 To intNumberOfCopies With Sheets("Sheet1") .Range("E1") = .Range("E1") + 1 .PrintOut End With Next intCounter End Sub If you need help getting this up and runniing just reply back and I can give you a hand... HTH "Ripple919" wrote: I have a form created in excel we use to write up work orders. I have now been asked to keep blank copies (about a hundred at a time) that are pre-numbered. Of course, I don't want to change the number, print, change the number, print etc, a hundred times to get all those blanks. Do you know how I can do this easily? any help would be appreciated. Jenni |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pre-numbered tickets
Ron and Jim,
Thank you both, I took both your suggestions combined them modifed them and came up with a great working copy! Thank you! "Jim Thomlinson" wrote: Here is some code for you. You need to put it into a module and attach a button to it. It increments the number in cell E1 on "Sheet1" by 1 and then prints a copy. It allows you to print a variable number of copies base on an input. Public Sub PrintCopies() Dim intNumberOfCopies As Integer Dim intCounter As Integer intNumberOfCopies = InputBox("Please enter the number of copes to print.", "Copies", 100) For intCounter = 1 To intNumberOfCopies With Sheets("Sheet1") .Range("E1") = .Range("E1") + 1 .PrintOut End With Next intCounter End Sub If you need help getting this up and runniing just reply back and I can give you a hand... HTH "Ripple919" wrote: I have a form created in excel we use to write up work orders. I have now been asked to keep blank copies (about a hundred at a time) that are pre-numbered. Of course, I don't want to change the number, print, change the number, print etc, a hundred times to get all those blanks. Do you know how I can do this easily? any help would be appreciated. Jenni |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for a tracking tool to track numbered raffle tickets | Excel Discussion (Misc queries) | |||
create numbered sortable numbered list in excel | Excel Discussion (Misc queries) | |||
deposit tickets | Excel Discussion (Misc queries) | |||
How do I set up raffle tickets to be numbered in Word | Excel Discussion (Misc queries) | |||
How can I create consecutivlely numbered tickets? | Excel Worksheet Functions |