Entering current time in specific cells
Solved/Closed
friskymarsh
Posts
2
Registration date
Wednesday October 7, 2015
Status
Member
Last seen
October 20, 2015
-
Oct 7, 2015 at 11:20 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 20, 2015 at 04:26 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 20, 2015 at 04:26 PM
Related:
- Insert the current date and time in the selected cell
- Popcorn time download - Download - Movies, series and TV
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Please insert the correct dvd-rom select ok and restart application nfsmw ✓ - Video Games Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- The system time is invalid hp ✓ - CPU & Desktop Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 7, 2015 at 12:19 PM
Oct 7, 2015 at 12:19 PM
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
Oct 20, 2015 at 02:40 PM
Oct 20, 2015 at 04:26 PM
target.offset(0,1) = now