Entering current time in specific cells
Solved/Closed
friskymarsh
Posts
2
Registration date
Wednesday 7 October 2015
Status
Member
Last seen
20 October 2015
-
7 Oct 2015 à 11:20
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Oct 2015 à 16:26
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Oct 2015 à 16:26
Related:
- Insert the current date and time in the selected cell
- Where is the insert key - Guide
- Insert the current date and time in cell a1 ✓ - Excel Forum
- Please insert the correct dvd-rom select ok and restart application nfsmw - Drivers Forum
- Please Insert the correct CD-ROM ✓ - Windows Forum
- Insert check mark in word - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
7 Oct 2015 à 12:19
7 Oct 2015 à 12:19
you can try to use the event
if you go to VBE
and click on your sheet
there you can try code
if you go to VBE
and click on your sheet
there you can try code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'prevent Select event triggering again
Application.EnableEvents = False
'ensure that only one cell is selected
If (Target.Count = 1) Then
'ensure that cell selected is from range A1:A10
If (Not Intersect(Target, Range(Cells(1, "a"), Cells(10, "A"))) Is Nothing) Then
'put current date and time
Target = Now
End If
End If
'enable the event again
Application.EnableEvents = True
End Sub
20 Oct 2015 à 14:40
20 Oct 2015 à 16:26
target.offset(0,1) = now