+ Reply to Thread
Results 1 to 6 of 6

"Defined Names" into "Data Validation" problem

  1. #1
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    383

    "Defined Names" into "Data Validation" problem

    Hi guys,


    when I plug a "Defined Names" into a "Data Validation" list, the Data Validation's "Error Alert stops"

    I want to be able to use "Defined Names" in "Data Validation" and have error alerts appear to the user, if the cell isn't an entry found within the Defined Names.

    Any ideas?
    Thanks!
    Thanks,

    JimmyWilliams

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,133

    Re: "Defined Names" into "Data Validation" problem

    That is a pretty general description--too general to actually be answered.

    I assume you are talking about using the List option. Can you give the specifics of what defined name you are using? What formula does it name?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,449

    Re: "Defined Names" into "Data Validation" problem

    Hi Jimmy,

    I think you need to put an equal sign in front of the DefineNames list in the Validation dialog. I also think you can't have a space in the name. See my example.
    Validation List needs Equal Sign.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    383

    Re: "Defined Names" into "Data Validation" problem

    Hi,

    thanks for the reply.

    See my sheet, I am having some trouble with conditional formatting and words.
    Please Login or Register  to view this content.

  5. #5
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,262

    Re: "Defined Names" into "Data Validation" problem

    Please Login or Register  to view this content.
    - its test for number with 5 digits and less
    And both condition is
    Please Login or Register  to view this content.

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,133

    Re: "Defined Names" into "Data Validation" problem

    Your latest problem seems to be different than your original question. Here is the solution to your conditional formatting question:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. replace all defined range names in the sheet that start with "Street" to "Road"
    By matrex in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-04-2016, 08:53 AM
  4. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. Replies: 1
    Last Post: 10-23-2013, 05:20 PM
  6. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  7. [SOLVED] Data validation: allow entry into a cell if other three cells have "X", "Y" and "Z"?
    By RogerRangeRover in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2013, 04:49 AM

Tags for this Thread

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