Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel - Enter Last Modified date into a cell

Comment:

I have been looking around for an Excel VB Macro or formula that will enter the date into a cell when any cells on the ROW have been modified. I am running Excel 2008 for Mac I have multiple columns (A through S), where some already contain data. I want to have the date automatically appear in column T when any of the cells (A-S) have been modified. I have many hundreds of rows. I am new to Macros but am very versed in formulas. Thank you for any assistance anyone can offer.

Name: DerbyDad03
Date: May 29, 2009 at 20:44:08 Pacific

Reply:

I don't use a Mac and I'm running Excel 2003 Pro, so this is what I would do: Right-click the sheet tab, choose View Code and paste this in: Private Sub Worksheet_Change(ByVal Target As Range) Range("T" & Target.Row) = Date End Sub Is that how you enter a Worksheet_Change macro in Excel 2008?

0

Msn Messenger Isnt Workin...

Outlook Exchange Server

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi everyone, I need some help here. I'm running excel MS office 2007. I have a main file that as a hyperlink to an external word doc. I'd like to place in an cell in the excel file the last modified d...

Summary: I am trying to get the date of a cell in Column E to update when I modify cells in column F, right now I have (from another forum): Private Sub Worksheet_Change(ByVal Target As Range) Range("E" & Ta...

Summary: After the first time that you enter "Mark" into a cell then each time thereafter when typing the letter "M" it will automatically autocomplete to "Mark". If you then enter a second name that begings w...