| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Log
Purrrrrfect! Thanks.
IP "egun" wrote: If you are trying to record the date/time any time cell C13 changes to "Y", then paste this code into that worksheet's code module (right-click on the worksheet's name tab, select "View Code"): Private Sub Worksheet_Change(ByVal Target As Range) ' ' This prevents recursion into this subroutine - ' set it back to True before you exit! ' Application.EnableEvents = False ' If (Target.Row = 13 And Target.Column = 3 And Target = "Y") Then ActiveSheet.Cells(16, 3) = Format(Now(), "mmm dd, yyyy h:mm AMPM;@") End If ' Application.EnableEvents = True End Sub Note: set cell C16 format to "Text", note "Date" or the VBA Format statement will not make any difference! HTH, Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| copy date based on date -refer to date range | Excel Programming | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Hybrid Mode
