+ Reply to Thread
Results 1 to 3 of 3

I need to modify this Module: add date in G and time in H when F changes

  1. #1
    Registered User
    Join Date
    11-01-2013
    Location
    oakland
    MS-Off Ver
    Excel 2007
    Posts
    1

    I need to modify this Module: add date in G and time in H when F changes

    Hello,

    I would like to modify this module. It was written so that any change made in column A would produce a date stamp in column b and a time stamp in column c. I need to a repeat this same process in column f. Any changes made in column f should produce a date stamp in column g and a time stamp in column h. How do I modify this module to include column f?


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("b2:b1000")) Is Nothing Then
    Target.Offset(0, 1) = Date
    Target.Offset(0, 2) = Time
    End If
    End Sub



  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: I need to modify this Module: add date in G and time in H when F changes

    Please add code tags to your code excerpt above.

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: I need to modify this Module: add date in G and time in H when F changes

    Or maybe just:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. modify date time cell to an excel format date time
    By rileyp in forum Excel General
    Replies: 12
    Last Post: 03-24-2013, 08:39 PM
  2. [SOLVED] Creating a macro (or module) to modify a cell's value based on automated entries
    By Julez80s in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2012, 01:51 PM
  3. Modify Date and Time
    By uberathlete in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2007, 01:16 PM
  4. Modify Last_Cell_Value Module
    By JustinL in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-08-2007, 12:19 PM
  5. Modify a module to insert a column
    By iwilkin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2005, 06:29 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1