I need a date stamp that doesn't change when you enter text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Stamp 1
Link cells when initials are entered, it time stamps the next??? 3
date/time stamp 7
Creating custom stamps in .pdf Adobe documents 1
Date stamp when a value is entered in a cell on another worksheet 1
NOW() function that won't change 4
Trying to run excel vba code when cell value changes from empty to entered value. 1
addind date stamp 0

Back
Top