Counter linked to Registry

  • Thread starter Thread starter Norm Taylor
  • Start date Start date
N

Norm Taylor

I want to add VB subroutine code, when I open an Excel
template form that I have built that a defined cell
receives a unique number by counting one greater than
when the form was previously opened from the VB code.
 
Norm
Paste this macro in the Workbook module. You access this module by
right-clicking on the icon to the left of the "File" of the worksheet menu
and selecting View Code. X-out of the VBE to return to the worksheet. As
written, this macro increments A1 by 1 each time the file is opened. HTH
Otto
Private Sub Workbook_Open()
Sheets("MySheet").Range("A1") = _
Sheets("MySheet").Range("A1") + 1
End Sub
 
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

Counter stops working 4
Triggering procedures 3
don’t see the Controls on the Forms generated at runtime 1
Track if any changes made after file opened 1
reseting hidden shape counter 1
Passing data to an event handler 3
Access Click in Table to Open Form 0
wildly varying execution speeds - is it the code? 3

Back
Top