+ Reply to Thread
Results 1 to 4 of 4

Excel VBA Format Cells and Track Changes

  1. #1
    Registered User
    Join Date
    09-17-2014
    Location
    Philippines
    MS-Off Ver
    Ms Office 2007
    Posts
    10

    Excel VBA Format Cells and Track Changes

    Hello everyone,
    Sample.xlsm
    I have a VBA code that track and log changes whenever a cell value (price, implementation date, description) is revised in all the worksheets. I got this from internet and tweak a little to customize according to my needs.

    There are still things I wanted to do but I don't know if possible and how to code it.
    1. Limit tracking changes to sheets "Project Data" and "Project Part Data" -- it won't track changes from all other sheets.

    2. Format cell value (old value and new value) logged in the tracker such that it has the same format with the worksheet it originated from (price should be number, implementation date should obvioulsy be date, description can either be general or text).

    I've attached a sample workbook.

    Hoping you could help.
    Thanks.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Excel VBA Format Cells and Track Changes

    1.
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-17-2014
    Location
    Philippines
    MS-Off Ver
    Ms Office 2007
    Posts
    10

    Re: Excel VBA Format Cells and Track Changes

    Quote Originally Posted by protonLeah View Post
    1.
    Please Login or Register  to view this content.
    That's quick! Thanks prontonLeah!
    I have an additional question though.. In project data and project part data sheets, there are columns that I would not like to track the changes. How will it be done?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Excel VBA Format Cells and Track Changes

    To check for specific columns use:

    Please Login or Register  to view this content.

    Note: Please do not quote whole posts when replying.

+ 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. Replies: 1
    Last Post: 08-23-2013, 06:24 AM
  2. Macro to format and track dates
    By TWent in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-08-2011, 10:17 AM
  3. Secretly Track Changes To Cells?
    By Spencer in forum Excel General
    Replies: 1
    Last Post: 05-30-2008, 07:59 PM
  4. Excel VBA: How to track changed cells
    By Jens Lenge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2005, 11:05 AM
  5. Track time in HH:min.min(Decimal) format
    By Garth Hales in forum Excel General
    Replies: 3
    Last Post: 02-16-2005, 01:01 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