Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a date stamp that doesn't change when you enter text
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a date stamp that doesn't change when you enter text
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how i change thai text to english text | Excel Worksheet Functions | |||
In Excel why does the date I enter automatically change by 1 day? | Excel Worksheet Functions | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
CHANGE TEXT TO DATE FORMAT | Excel Discussion (Misc queries) |