G Guest Aug 30, 2006 #1 I would like to figure out how to get the current date into a cell when a user clicks the cell. Thanks, Tricia Gall
I would like to figure out how to get the current date into a cell when a user clicks the cell. Thanks, Tricia Gall
D Don Guillett Aug 30, 2006 #2 right click sheet tab>view code>insert this>save now when you select cell a2 the date will be today Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address <> "$A$2" Then Exit Sub Target = Date End Sub
right click sheet tab>view code>insert this>save now when you select cell a2 the date will be today Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address <> "$A$2" Then Exit Sub Target = Date End Sub
G Guest Aug 30, 2006 #3 Thanks!!!! Don Guillett said: right click sheet tab>view code>insert this>save now when you select cell a2 the date will be today Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address <> "$A$2" Then Exit Sub Target = Date End Sub Click to expand...
Thanks!!!! Don Guillett said: right click sheet tab>view code>insert this>save now when you select cell a2 the date will be today Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address <> "$A$2" Then Exit Sub Target = Date End Sub Click to expand...
