+ Reply to Thread
Results 1 to 2 of 2

Data Validation Alert text linked to specific cell

  1. #1
    Registered User
    Join Date
    11-27-2018
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel, Word, PowerPoint
    Posts
    1

    Data Validation Alert text linked to specific cell

    I'm using Excel 2011 for Mac.

    In my spreadsheet, the value in cell A60 is a person's age (for eligibility of benefits) that changes depending on data entry in other cells. The number that may be entered into cell A27 must not be lower than the age in A60, whatever that might be. The restriction in A27 works fine, but I want the "Stop" message for A27 to read, "Age cannot be less than [retrieve the value in A60]". I can't figure out how to get the message to tell the data entry person the lowest age that can be entered into A27, other than "Age cannot be lower than the age in cell A60", which is pretty clumsy.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    13,504

    Re: Data Validation Alert text linked to specific cell

    Welcome to the Forum Otto Wirke!

    Data Validation does not support formulas/cell references in the messages. You would have to remove your data validation rule and use VBA. Something like this:
    Please Login or Register  to view this content.
    I have not tested this but would be happy to do so if you provide your file. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Last edited by 6StringJazzer; 11-27-2018 at 10:16 PM. Reason: added blue text
    Jeff

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會

    If someone helped you please click on the star icon at the bottom of their post
    If your problem is solved please go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

+ 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