| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a "one time only" calculation field?
I need to create a form (using Excel) - and in that form I need a date field
to populate. The problem is I need that to happen the first time only. So, "ctrl ;" puts a date in a field, and if there is a way to create an embedded process that causes that to happen the first time the form is opened, would help me get done what I need to happen. Anyone have suggestions? -- Neal |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a "one time only" calculation field?
All of the date functions such as Today() and Now() are volatile meaning that
they will automatically update themselves. Other than Ctrl ; or using VBA to create a UDF that you can use in your sheet there is not much you can do... -- HTH... Jim Thomlinson "Neal" wrote: I need to create a form (using Excel) - and in that form I need a date field to populate. The problem is I need that to happen the first time only. So, "ctrl ;" puts a date in a field, and if there is a way to create an embedded process that causes that to happen the first time the form is opened, would help me get done what I need to happen. Anyone have suggestions? -- Neal |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a "one time only" calculation field?
Jim,
Appreciate the suggestion and I was hoping for some tool within Excel that would permit this. Thanks and I will respond with what I end up doing to address this. Thanks again! -- Neal "Jim Thomlinson" wrote: All of the date functions such as Today() and Now() are volatile meaning that they will automatically update themselves. Other than Ctrl ; or using VBA to create a UDF that you can use in your sheet there is not much you can do... -- HTH... Jim Thomlinson "Neal" wrote: I need to create a form (using Excel) - and in that form I need a date field to populate. The problem is I need that to happen the first time only. So, "ctrl ;" puts a date in a field, and if there is a way to create an embedded process that causes that to happen the first time the form is opened, would help me get done what I need to happen. Anyone have suggestions? -- Neal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time v cost calculation in Excel 2002 (XP) | Excel Discussion (Misc queries) | |||
| Question calculation time and Index formula | Excel Worksheet Functions | |||
| Time calculation | Excel Worksheet Functions | |||
| How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
| elapsed time calculation | Excel Discussion (Misc queries) | |||
Linear Mode
