+ Reply to Thread
Results 1 to 2 of 2

Confirm editing of a populated cell with VBA

  1. #1
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    Confirm editing of a populated cell with VBA

    hi guys

    I found this code online ...

    Please Login or Register  to view this content.
    It prompts the user if the value in A1 is changed.

    Can this code be edited so it prompts the user for all populated cells.

    I want this message to only appear if cells which already contain values are changed and not is the cell is blank.

    many thanks

  2. #2
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Confirm editing of a populated cell with VBA

    I believe it takes 2 Subs.
    The first one stores the current value in a comment when the cursor enters the cell, and the 2nd one checks to see if the comment is empty.
    Please Login or Register  to view this content.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

+ 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