+ 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
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    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
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Hover Text Linked to a Data Validation List
    By Henny1986 in forum Excel General
    Replies: 5
    Last Post: 11-18-2020, 09:33 AM
  2. Replies: 7
    Last Post: 10-02-2017, 12:09 PM
  3. [SOLVED] Data validation based on another cell containing specific text
    By Sph01 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2013, 05:51 AM
  4. Data Validation Alert with Formula
    By jlo33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2013, 05:29 PM
  5. Data Validation issue - alert when cell is blank
    By pbody in forum Excel General
    Replies: 1
    Last Post: 01-17-2013, 08:39 PM
  6. Data Validation for linked cell
    By gilbert in forum Excel General
    Replies: 1
    Last Post: 06-13-2011, 05:24 AM
  7. Data Validation linked to cell Formula
    By Buzz in forum Excel General
    Replies: 4
    Last Post: 04-30-2006, 03:55 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