+ Reply to Thread
Results 1 to 3 of 3

Message box for cell change

  1. #1
    Registered User
    Join Date
    10-25-2004
    Posts
    12

    Message box for cell change

    I have a fairly large spreadsheet in which I have protected certain cells from being accidentially modified by the user by setting Data -> Validation -> Custom -> =. I have found that it would be much more beneficial if I could instead have a pop-up box when a user tried to modify a certain cell, asking for verification before allowing them to modify the cell. Is there a way to specify certain cells to call a pop-up box when a user tries to modify them?
    Last edited by Prometheus; 09-23-2005 at 11:53 AM.

  2. #2
    STEVE BELL
    Guest

    Re: Message box for cell change

    You might want to look at the worksheet selection change event.

    Change $A$1 to your cell address
    Or you can generalize it by looking at
    target.row and/or target.column

    If target.Address = "$A$1" then
    'code for pop-up
    Else ' alternate code
    End If

    Post back if you need actual code.
    --
    steveB

    Remove "AYN" from email to respond
    "Prometheus" <[email protected]> wrote
    in message news:[email protected]...
    >
    > I have a fairly large spreadsheet in which I have protected certain
    > cells from being accidentially modified by the user by setting Data ->
    > Validation -> Custom -> =. I have found that it would be much more
    > beneficial if I could instead have a pop-up box when a user tried to
    > modify a certain cell asking for verification before allowing them to
    > modify the cell. Is there a way to specify certain cells to call a
    > pop-up box when a user tries to modify them?
    >
    >
    > --
    > Prometheus
    > ------------------------------------------------------------------------
    > Prometheus's Profile:
    > http://www.excelforum.com/member.php...o&userid=15697
    > View this thread: http://www.excelforum.com/showthread...hreadid=466894
    >




  3. #3
    Registered User
    Join Date
    10-25-2004
    Posts
    12
    Delayed reply, been busy lately

    Actually, if you could post a few lines of sample code that would be great, I've never worked with the worksheet selection change event.

    Thanks.

+ 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