| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Date and time in Cell
Hello,
I am looking for a line of code that I could add to the end of my macro that would insert the date and time the macro was first run into a cell named "vLeadWriteDate". Any help would be great. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert Date and time in Cell
vLeadWriteDate = now
Be sure the column is wide enough or you will see ########. "Eric" wrote: Hello, I am looking for a line of code that I could add to the end of my macro that would insert the date and time the macro was first run into a cell named "vLeadWriteDate". Any help would be great. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert Date and time in Cell
If you only want the first occurance, then
If vLeadWriteDate "" The 'Do nothing Else vLeadWriteDate = now End If "Eric" wrote: Hello, I am looking for a line of code that I could add to the end of my macro that would insert the date and time the macro was first run into a cell named "vLeadWriteDate". Any help would be great. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert Date and time in Cell
I'll get this right pretty soon. This should do it:
If Range("vLeadWriteDate") "" The 'Do nothing Else Range("vLeadWriteDate") = now End If "JLGWhiz" wrote: If you only want the first occurance, then If vLeadWriteDate "" The 'Do nothing Else vLeadWriteDate = now End If "Eric" wrote: Hello, I am looking for a line of code that I could add to the end of my macro that would insert the date and time the macro was first run into a cell named "vLeadWriteDate". Any help would be great. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto insert Date & Time when another cell is populated | Excel Discussion (Misc queries) | |||
| Auto insert date/time | Excel Worksheet Functions | |||
| insert date and time picker | Setting up and Configuration of Excel | |||
| how do I insert the current time (static) and date in a cell? | Excel Discussion (Misc queries) | |||
| Auto date/time insert when data entered into an adjacent cell | Excel Worksheet Functions | |||
Hybrid Mode
