Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i have a cell number increase by 1 each time file opened

i would like to know how to formulat a cell so each time the number in the
cell will increase by 1 or 5. there will be 5 people who access this file
only one at a time.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default how do i have a cell number increase by 1 each time file opened

Cannot be done through formatting.

Need code to run when opening the workbook.

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

Right-click on the Excel Icon left of "File" and select "View Code".

Copy/paaste the above into that module.

Alt + q to return to the Excel window.

Make sure there is a number in the cell.

Save, close and re-open to see the number increase by 1


Gord Dibben MS Excel MVP

On Sat, 24 May 2008 17:52:00 -0700, DJbase
wrote:

i would like to know how to formulat a cell so each time the number in the
cell will increase by 1 or 5. there will be 5 people who access this file
only one at a time.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel file opened automaticaly at specified time & date aligaz Excel Discussion (Misc queries) 2 December 17th 07 05:45 PM
Number in cell increase with increase in font size. Value increases with increase in font.[_2_] Excel Discussion (Misc queries) 2 August 9th 07 01:58 PM
how do i increase invoice number everytime its opened? stacey Excel Discussion (Misc queries) 1 March 3rd 06 11:37 AM
How to automtically increase a number every time a file is used falcp Excel Discussion (Misc queries) 1 January 16th 06 04:29 PM
auto insert invoice number that increases by one each time opened Michael HPSC Excel Worksheet Functions 3 November 29th 05 09:10 AM


All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"