formula to insert time of day in excel cell

  • Thread starter Thread starter novice567
  • Start date Start date
N

novice567

How can I set up an excel worksheet to track time so that when I click on the
required excel cell it automatically inserts time of the day
 
right click the sheet tab>view code>double_click event>

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
If Target.Address <> _
Range("k1").Address Then Exit Sub
Target = Time

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
'Cannot insert object' message when I try to put a button on a worksheet 7
Trailing 30 days sum calculation with excel 1
Excel Excel IF variable based on time of day 0
Use first day of month formula in a drop down list 3
how do I enter cell value automatically to textbox? 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Inserting Picture Into Protected Worksheet 1

Back
Top