Field whose value increments automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a field which automatically increments by 1 every
time I open the worksheet?

Thanks...
 
Only with code. Use the Workbook_Open event procedure to
increment a value in a cell. For example, put the following code
in the ThisWorkbook code module:

Private Sub Workbook_Open()
With ThisWorkbook.Worksheets("Sheet1").Range("A1")
.Value = .Value + 1
End With
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Thanks very much - that's very helpful. Is there any way to do it with a
template rather than a normal workbook? This method works great if the file
is saved each time, but when using a template to create a new workbook, using
the SAVE command will save the new workbook and not make any changes to the
template itself. Is there any way to automatically save a new version of the
template?

TIA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Increment numerically ordered rows 3
Incrementing values 2
Linked Cells, Increment Sheet Number Ref. 3
Dragging Text or Date Fields to Copy 2
Using macro recorder increment cell by one? 4
Date Functions 1
numbering items in a cell 5
Increment and replace a cell value 1

Back
Top