Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sequential number
I want to a sequential number to fill in automatically each time the form is
filled out. |
#2
|
|||
|
|||
Malissa,
A simple way would be to use something like this, you could assign it to a button, an open or before print event. Sheets("Sheet1").Range("A1").Value = _ Sheets("Sheet1").Range("A1").Value + 1 For other ways to do this or if this is going to be used in a temple have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Malissa" wrote in message ... I want to a sequential number to fill in automatically each time the form is filled out. |
#3
|
|||
|
|||
Check out John McGimpsey's site for method.
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Gord Dibben Excel MVP On Mon, 15 Aug 2005 13:22:04 -0700, "Malissa" wrote: I want to a sequential number to fill in automatically each time the form is filled out. |
#4
|
|||
|
|||
Take a look he
http://www.mcgimpsey.com/excel/sequentialnums.html In article , "Malissa" wrote: I want to a sequential number to fill in automatically each time the form is filled out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
doubling a number X number of times | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Controlling Sequential Numbers | Excel Discussion (Misc queries) | |||
Convert week number into calendar month? | Excel Worksheet Functions |