Results 1 to 6 of 6

Thread: All Data Validation Message Boxes Appear in Same Location Despite Cell Selected

  1. #1
    Junior Member
    Join Date
    Sep 2016
    Posts
    3
    Rep Power
    0

    Question All Data Validation Message Boxes Appear in Same Location Despite Cell Selected

    Hello:

    Here is chronicle of problem. Excel 2007. I have seven cells each with a different data type. For each cell I want to have a message that appears when the cell is selected. Therefore I select the first cell of interest (C1) and select data validation. I fill out only the Message title and the text of the message. I do not restrict the data in any way (i.e. no list box, no data type restriction and no error message). I position the message box close to the Cell C1. Now I go to cell G1 and use the data validation to create a message box for the cell G1 , which has a different title and different text. I positioned the message box close to Cell G1. When I am finished I closed the data validation. Now: Selection of cell C1 gives the appropriate message box for Cell C1 but the message box pops up in the location near cell G1. If I selected Cell G1 the appropriate message box for G1 appears near G1. It appears that Excel 2007 correctly 'remembers' the text assigned for the message box for the particular cell but not the physical location; instead the last physical location where a data validation box was created is the location where all will pop up. Has anyone observed this rather unusual behavior?
    Thanks in advance for any insight on this.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Yes. An annoying issue indeed. I'll check if this is the same for subsequent versions of Excel.

    Assuming you are looking for a solution to this?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Member rollis13's Avatar
    Join Date
    Nov 2012
    Posts
    36
    Rep Power
    0
    Yes, it's still the same in Excel 2010.

  4. #4
    Junior Member
    Join Date
    Sep 2016
    Posts
    3
    Rep Power
    0
    Hello Excel Fox:

    Thanks for your prompt reply. Yes I am looking for a solution for the problem. I had also thought of using Comments but then one has the red triangle in the upper right hand corner of the cell, which is distracting when there are lots of cells that need messages. It appears that Excel has a bug in re keeping the tether for a Data Validation message box to the particular cell. Waaay back (probably in 2002 or so) I has this problem but in that case the sheet was such that one did not have to mover around to see different sections : In that case I created a 'Message Area' in a specific location in order to direct the users attention any messages that would be associated with a particular cell. In this case I can't do that due to the need for navigation within the sheet (Hmmm, I suppose I could freeze a row or column and use the 'Message area' technique, but really! Best regards.

  5. #5
    Junior Member
    Join Date
    Sep 2016
    Posts
    3
    Rep Power
    0
    Hello Rollis13:

    Thanks for you effort demonstrating the persistence of the problem in Excel 2010. I'm going to try to look at Excel 2013 and see if it persists there. Best regards.

  6. #6
    Junior Member
    Join Date
    Sep 2016
    Posts
    1
    Rep Power
    0
    Quote Originally Posted by emarineli View Post
    Hello:

    I fill out only the Message title and the text of the message. I do not restrict the data in any way (i.e. no list box, no data type restriction and no error message). I position the message box close to the Cell C1. Now I go to cell G1 and use the data validation to create a message box for the cell G1 , which has a different title and different text. I positioned the message box close to Cell G1.
    Hi emarineli,

    Have you tried the default behaviour i.e. without manually changing the position of message ?. I have tried it in Excel 2013 using default way i.e. let it display near selected cell and it shows appropriately as per cell selection. Seems no problem.

    However, if I manually change message display position by dragging, it changes the position for both cells.

Similar Threads

  1. Replies: 14
    Last Post: 10-23-2013, 01:24 PM
  2. Replies: 4
    Last Post: 07-27-2013, 01:34 PM
  3. How To Lock Or Protect Cell Using Data Validation
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-06-2013, 01:57 AM
  4. Number validation in Text Boxes VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 05-17-2012, 02:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •