Record timestamp in one column automatically

**springa** · 02-10-2009, 06:46 AM

Hi all,

I am using a section of code to automatically update a column with date/time stamp and it works perfectly, I am looking for a way to do this twice in the same spreadsheet though. I.e. when someone updates Column B, Colum C is updated and when someone updates Column D, Column E is updated. Need the same to occur when columns F and G are updated too. Below is the code I am currently using:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 2 Then
Target.Offset(0, 1).Value = Now()
End If
End Sub

Please helP! Thanks...

**VBA Noob** · 02-10-2009, 09:38 AM

springa,

Please edit your post to include code tags and avoid hijacking a thread again.

These are the two rules you have broken
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

VBA Noob

Record timestamp in one column automatically

LinkBack

Thread Tools

Rate This Thread

Display

Record timestamp in one column automatically

Re: Record timestamp in one column automatically

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions