<div>
Code something like the following into the Sheetchange event at either the worksheets or workbook objects.<br />

<pre><code id="code-20-40250492-1">Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Target.Column = 1 Then
        Target.Offset(0, 1).Value = Now
    End If
End Sub</code></pre>
</div>


Code something like the following into the Sheetchange event at either the worksheets or workbook objects.


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Target.Column = 1 Then
        Target.Offset(0, 1).Value = Now
    End If
End Sub

<div>
Thanks very much. &nbsp;EXACTLY what I was looking for.
</div>


Thanks very much.  EXACTLY what I was looking for.

<div>
<div class="content wysiwyg-content">
Hi. &nbsp;I'd like a little help with coding an Excel sheet.<br />
<br />
I would like that when data is entered into the first cell (A1), the timestamp of entry automatically appears in B1 and cursor advances to C1 for next input.<br />
<br />
When data is entered to C1, I would like the sheet to advance to the next row and begin the process over again with cursor awaiting input in A2.
</div>
</div>


Hi.  I'd like a little help with coding an Excel sheet.

I would like that when data is entered into the first cell (A1), the timestamp of entry automatically appears in B1 and cursor advances to C1 for next input.

When data is entered to C1, I would like the sheet to advance to the next row and begin the process over again with cursor awaiting input in A2.

Excel Coding:  Automatic Datestamp, Field and Row Advance

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.