+ Reply to Thread
Results 1 to 4 of 4

Message box for any value that changes?

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    Michigan
    MS-Off Ver
    2003
    Posts
    15

    Message box for any value that changes?

    Is it possible to have a message box popup if a populated field is changed on the worksheet. I have a workbook that is used for bingo and several people use it. Some of them are not use to computers. I would like a way to warn them if they are changing a value that has already been input.

    I have attached a copy of the sheet that I need help with.

    Thank You

    Lloyd
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Message box for any value that changes?

    How about password protection so that only those authorized to make changes are able to do so. All others can only review and not make changes. Would that work?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-25-2014
    Location
    Michigan
    MS-Off Ver
    2003
    Posts
    15

    Re: Message box for any value that changes?

    It is protected on all cells that does not need input. It is the cells that needs values in that I am trying to bring to their attention if they try to change the cell after a value has been entered. Hope this explains it so you understand what I am trying to do.

    Thank

    Lloyf

  4. #4
    Registered User
    Join Date
    11-25-2014
    Location
    Michigan
    MS-Off Ver
    2003
    Posts
    15

    Re: Message box for any value that changes?

    It is protected on all cells that does not need input. It is the cells that needs values in that I am trying to bring to their attention if they try to change the cell after a value has been entered. Hope this explains it so you understand what I am trying to do.
    sorry about the double post.
    Thank

    Lloyd

+ 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. Adding an input message to each cell to bring back corrsponding message
    By Nic31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2014, 09:28 AM
  2. An error message on open - a totally blank VBA message box
    By Mr_Tigas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2013, 11:29 AM
  3. [SOLVED] How to pop up a warning message before any Excel automatic update link reminder message
    By billj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2013, 10:41 AM
  4. Extracting mail message(outlook) table in the message body
    By andywsw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 10:14 PM
  5. need of pop up message dynamically using data validation input message method
    By vba_life in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2010, 09:03 AM
  6. replace VBA run-time error message with custom message
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-14-2006, 11:05 AM
  7. [SOLVED] Intercept/replace standard 'cell protected' message with my own message?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2006, 10:35 AM

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