Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-17-2015, 07:51 PM
excelledsoftware excelledsoftware is offline Add a serial number to an invoice Windows 7 64bit Add a serial number to an invoice Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

This can be done using an on open command. This will be in the visual basic editor under thisworkbook.

Code:
Private Sub Workbook_Open()
  Range("E15").Value = Range("E15").Value + 1
End Sub
Now there are ways you could probably do it with a formula or even having a button that says "New Invoice" which you would just attach the middle of the code to it.

Let me know if this is what you are looking for.

Thanks
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a serial number to an invoice Converting serial number to years, months and days hannu Excel 6 02-14-2013 09:21 PM
Add a serial number to an invoice Increase serial number for every print atomtm Word 1 06-15-2012 05:39 AM
Add a serial number to an invoice Serial Number Issue rehan5001 Excel 1 06-08-2011 02:46 AM
Add a serial number to an invoice Invoice Number Generation mrphilk Excel 2 06-08-2010 12:39 PM
Help needed using the serial number date with sumifs - whole office is stumped FraserKitchell Excel 3 01-06-2010 12:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:38 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