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 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 20, 2015 at 04:26 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 20, 2015 at 04:26 PM
Related:
- Which function will you use to enter current time in a worksheet cell?
- Which function will you use to enter current time in a worksheet cell ✓ - Office Software Forum
- Current time by clicking comm button in excel - Excel Forum
- Activeworkbook.worksheets current worksheet ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
- How to enter @ in laptop - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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