+ Reply to Thread
Results 1 to 7 of 7

Macro to color bacground of the cell and log time if cells content changed

  1. #1
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110

    Macro to color bacground of the cell and log time if cells content changed

    Hi Everyone! I have an excel file which is used by a few people. This file is a share file which is used monthly. The users change their previous comments, or do nothing. I would like to have a macro which in case a cells old value is changed (old comments deleted and added new ones, or suplementary comments added to the old ones) it automatically colors the background of the cell to be red. And it also adds the time and date when the change was made in the same row, column "H".
    I hope I was understandable.

    Thank you in advance for your help.

  2. #2
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110
    Please, could someone help me??
    Thank you!

  3. #3
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110

    Unhappy

    Is this really so hard that no one calp me?????

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Are you talkng about Cell Vomments or text within the cell? There's not really a suitable way to trap the cell's content that i can think of.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    maybe this might help
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110
    Dear Roy!

    This is PERFECT!! ) Thanks a lot.
    However there is one small thing though... The function Now() should be but allways changed cells row but the column "H".

    Can you help me on this one?

    Thank you in advance!

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Try
    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)

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