Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record the date on which the record is made
Hi,
I would like to input some data and the dates on which I input these data in the adjacent cells on an Excel spreadsheet. An example is like this one: Data Dates on which I input the data 12 30-6-2006 13 30-6-2006 15 01-7-2006 17 02-7-2006 Could you tell me the way of doing this using VBA and the way using the built-in functions of Excel? Thank you. David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record the date on which the record is made
Hi David
Built-in functions cannot pust values to remote cells, you need VBA for this. Rightclick sheet tab, choose View Code, paste this in: Private Sub Worksheet_Change(ByVal Target As Range) Dim Cel As Range For Each Cel In Target If Cel.Column = 1 Then Cel.Offset(0, 1).Value = Now 'or Date End If Next End Sub HTH. Best wishes Harald "cyberdude" skrev i melding oups.com... Hi, I would like to input some data and the dates on which I input these data in the adjacent cells on an Excel spreadsheet. An example is like this one: Data Dates on which I input the data 12 30-6-2006 13 30-6-2006 15 01-7-2006 17 02-7-2006 Could you tell me the way of doing this using VBA and the way using the built-in functions of Excel? Thank you. David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
Formula that will record the time and date when an entry is made on a sheet | Excel Worksheet Functions | |||
Finding last record in month for each of several types of record. | Excel Programming | |||
Record Macro - Record custom user actions | Excel Programming | |||
Record changes made from a vb form | Excel Programming |