assign a macro to a cell

I have never used macro's before in excel so I am a bit clueless.

I want to be able to click on a cell (e.g. G11) and when I click the cell the current date and time appears in cell H11.

Tips and advice would be much appreciated.

You could insert a command button (found in developer > add > command button) and then assign a macro to said button that displays the date and time in H11. Is that helpful?

I know I can do it that way but I want to do it by clicking on the actual cell. Ideally so I have to double click on the cell for the date/time to appear in the other cell. I want to do this on numerous cells e.g.

Cell G11 when double clicked to show date/time cell H11.
Cell G12 when double clicked to show date/time in cell H12 etc.

Also when I click on say G11 I only want it to update the date/time in cell H11 and not in cells H12,H13 etc.

Any VBA pros out there, would you recommend a good book/source to learn the basics?

Originally Posted by arlu1201

Right click on the sheet containing the data and enter this code -

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 7 Then Range("H" & Target.Row).Value = Date & " " & Time
End Sub

As soon as you double click the cell in column G, H will show the date and time.

This is great, how do I edit this so it just does it for say for cells G11 and H11?

Originally Posted by arlu1201

Try this

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address = "$G$11" Then Range("H" & Target.Row).Value = Date & " " & Time
End Sub

Thank you Arlu, you have been really helpful. How can I expand the Macro for example I need to do the same thing for I11 to show the date/time of J11?