Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get a unique number on a form when I open it each time?
I want to create a form/template that an end user can open each time and have
a unique number appear in a field. Would like the number to be incremental, if possible. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get a unique number on a form when I open it each time?
Maybe something like this........
Private Sub Workbook_Open() Dim username username = ActiveWorkbook.BuiltinDocumentProperties.Item("aut hor") Range("a1").Value = username & "-" & Date & "-" & Time End Sub Vaya con Dios, Chuck, CABGx3 "Patti" wrote: I want to create a form/template that an end user can open each time and have a unique number appear in a field. Would like the number to be incremental, if possible. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get a unique number on a form when I open it each time?
Patti
You will need to employ a little VBA. See John McGimpsey's site for code. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Gord Dibben MS Excel MVP On Fri, 8 Jun 2007 10:27:00 -0700, Patti wrote: I want to create a form/template that an end user can open each time and have a unique number appear in a field. Would like the number to be incremental, if possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I generate a unique number each time a form is printed? | Excel Worksheet Functions | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
ASSIGNING A NEW NUMBER TO A WORKSHEET EVERY TIME IT IS OPEN | Excel Worksheet Functions | |||
how to auto increment a number each time i open the worksheet | Excel Worksheet Functions | |||
Can excel automatically number itself each time you open a documen | Excel Discussion (Misc queries) |