Add a serial number to an invoice

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Add a serial number to an invoice

FAQ

Thread Tools

Display Modes

02-17-2015, 07:51 PM

excelledsoftware excelledsoftware is offline

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

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting serial number to years, months and days	hannu	Excel	6	02-14-2013 09:21 PM
Increase serial number for every print	atomtm	Word	1	06-15-2012 05:39 AM
Serial Number Issue	rehan5001	Excel	1	06-08-2011 02:46 AM
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.