Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 05-28-2013, 04:38 PM
macropod's Avatar
macropod macropod is offline need help with numbering NCR forms Windows 7 32bit need help with numbering NCR forms Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Teresa,

Assuming you already have your NCR sheets sorted, you could use a macro like:
Code:
Sub PrintNCRSeries()
Dim StrSeries As String, i As Long, j As Long, k As Long
With ActiveSheet
  With .Range("F12")
    If InStr(.Value, "-") > 0 Then
      i = Split(.Value, "-")(1) + 1
      j = Split(.Value, "-")(1) + 10
    End If
  End With
  StrSeries = InputBox("What is the range to print? (eg 1-10)", _
    "NCR Print Manager", Format(i, "0000") & "-" & Format(j, "0000"))
  If StrSeries = "" Then Exit Sub
  i = Split(StrSeries, "-")(0)
  j = i
  If InStr(StrSeries, "-") > 0 Then j = Split(StrSeries, "-")(1)
  For k = i To j
    .Range("F12").Value = "FE-" & Format(k, "0000")
    .PrintOut Copies:=3
  Next
End With
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
ncr forms, numbering, numbering forms



Similar Threads
Thread Thread Starter Forum Replies Last Post
forms mrmagoo Word 2 06-28-2012 01:25 PM
Forms textboom Word VBA 0 02-23-2011 07:51 AM
Document unique numbering / forms JamesF Word 0 11-22-2010 03:52 AM
Forms help benji842 Word 0 06-24-2010 06:04 AM
Forms oo7juk Word 0 10-09-2009 01:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft