View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
howard howard is offline
external usenet poster
 
Posts: 68
Default Entering (NOW) information on click

Thanks to everyone who answered. We really appreciate you folks.
--
Howard


"JLGWhiz" wrote:

See if this works for you. I used Range("B2"), but you can change that to
whatever you want.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)
If Not Intersect(Target, Range("B2")) Is Nothing Then
Target.Value = Now
End If
End Sub




"Howard" wrote in message
...
Is there any way to put code in the WorkBook Module so that when a person
clicks on a cell (and only when they click on this cell) on any sheet, it
would put in the current time and date?
--
Howard



.