Capture and display the cell number being double click as a History record

[EvelynLu]

Hi All expert,

Can I check with you.. As I have a Tools booking system. However, notice, people book already and then unbook later.
So I want to track who double click the cell to unbook. How? I intend to record down the action that the user did in the form. Now I can record down the user name and date when people access the form but there is no record to see what cell they have double click. Hence, wonder how can I capture the cell number that they have double click on using VBA under sub routine Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

To record the history for user name and date, here is my code.
Cells(3, 9).Select
Do While ActiveCell.Value <> ""
ActiveCell.Offset(1, 0).Activate
Loop

ActiveCell.Value = Now
ActiveCell.Offset(0, 1).Activate
ActiveCell.Value = Application.UserName
ActiveCell.Offset(0, 1).Activate
Cells(3, 9).Select
'-----------------------

Any advise how can I add in one more line in above script to record down the cell number being double click? Your help is greatly appreciated. Thank you.

 

[jmacleary]

You can access the address of the clicked cell with 'Target.Address'. This returns an address such as $A$3. So you would want something like: ActiveCell.Offset(0, 2).Value=Target.Address

 

[EvelynLu]

Yes it works.... Thank you soooo much!!! for your kind help....