formula to insert time of day in excel cell

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
 
D

Don Guillett

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
Excel Excel IF variable based on time of day 0
Trailing 30 days sum calculation with excel 1
Inserting Picture Into Protected Worksheet 1
Basic Calculation obstacle 3
Use first day of month formula in a drop down list 3
Can I insert a picture depending on the contents of another cell? 1

Top