![]() |
#1
|
|||
|
|||
![]()
Hi Everyone,
So I am have a code that I got for Excel to print the serial numbers sequentially but I am wondering what I would have to change in the code to work with a text field called Serialnumber to do the same as it does for Excel. Here is the code. I am not very good with VBA so that is why I am coming here for help. ub PrintJobs() Dim i As Long, startnum As Long, lastnum As Long startnum = Application.InputBox("Enter the first job number to be printed", "Print Job Number", 1, , , , , 1) lastnum = Application.InputBox("Enter the last job number to be printed", "Print Job Number", 1, , , , , 1) For i = startnum To lastnum Range("D7").Value = i ActiveWindow.SelectedSheets.PrintOut Next End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
4ener | Word | 9 | 02-24-2019 07:50 AM |
Sequential numbering in Word - Unique numbers for table rows | krips | Word | 1 | 03-21-2018 05:06 AM |
![]() |
srinivasaru | Excel Programming | 8 | 04-03-2017 12:53 PM |
![]() |
woodyear99 | Word | 1 | 07-18-2016 08:28 PM |
![]() |
atomtm | Word | 1 | 06-15-2012 05:39 AM |