Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a template with an automatic Number Systen
I want to set up a template that when opened in one cell will give me #1 the
first time it was used, then #2 the second time. I want the numbers to be incremental in 1's, Any suggestions please |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a template with an automatic Number Systen
Hi,
Several techniques here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Mike "gigglygover" wrote: I want to set up a template that when opened in one cell will give me #1 the first time it was used, then #2 the second time. I want the numbers to be incremental in 1's, Any suggestions please |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a template with an automatic Number Systen
Is your template a true Template(*.XLT)
Private Sub Workbook_Open() if thisworkbook.path = "" then 'it's never been saved, so increment Sheet1.Range("H16").Value = Sheet1.Range("H16").Value + 1 end if End Sub Placed in Thisworkbook module of the Template from which your workbooks are created. Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 09:24:00 -0700, gigglygover wrote: I want to set up a template that when opened in one cell will give me #1 the first time it was used, then #2 the second time. I want the numbers to be incremental in 1's, Any suggestions please |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a template with an automatic Number Systen
Getting too old for this<g
Forgot to mention...........in the *.xlt you must enter a 1 in H16 then save. Gord Dibben MS Excel MVP On Thu, 09 Oct 2008 14:58:41 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Is your template a true Template(*.XLT) Private Sub Workbook_Open() if thisworkbook.path = "" then 'it's never been saved, so increment Sheet1.Range("H16").Value = Sheet1.Range("H16").Value + 1 end if End Sub Placed in Thisworkbook module of the Template from which your workbooks are created. Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 09:24:00 -0700, gigglygover wrote: I want to set up a template that when opened in one cell will give me #1 the first time it was used, then #2 the second time. I want the numbers to be incremental in 1's, Any suggestions please |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a template with an automatic Number Systen
I don't know if "gigglygover" understands programmers language, I surely
don't, as with the link to McGimpsey, to to able to get it right one needs to have the programmers software and knowledge to understand all this. I have a simular problem, and all we ask is that someone explain it to us in good old english. "gigglygover" wrote: I want to set up a template that when opened in one cell will give me #1 the first time it was used, then #2 the second time. I want the numbers to be incremental in 1's, Any suggestions please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn off the automatic Help screen in a template? | Excel Discussion (Misc queries) | |||
Automatic installer or what for distributing a template? | Excel Discussion (Misc queries) | |||
Automatic Template Help in task pane | Excel Discussion (Misc queries) | |||
Setup Purchase Order Template to have a automatic number system? | Excel Worksheet Functions | |||
Automatic filename generation template | Excel Discussion (Misc queries) |