I need code for a date stamp in one cell when you enter text in one other
cell.
Application: A form that will require you to enter your name as a signature
and that it will automatically enter a datestamp above it.
I need code for a date stamp in one cell when you enter text in one other
cell.
Application: A form that will require you to enter your name as a signature
and that it will automatically enter a datestamp above it.
Change A1 and A2 below to suit your applicaton.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'================================================
'Inserts date in A1 is any value entered in A2
'Clearcontents on A1 if A2 is clearcontents
'================================================
If Not Range("a2").Value = "" Then
Range("a1").Value = Date '& " " & Time
Else
Range("a1").Value = ""
End If
End Sub
Vaya con Dios,
Chuck, CABGx3
"Eric Hersey" wrote:
> I need code for a date stamp in one cell when you enter text in one other
> cell.
>
> Application: A form that will require you to enter your name as a signature
> and that it will automatically enter a datestamp above it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks