+ Reply to Thread
Results 1 to 2 of 2

Default in Validation List which uses a table range

  1. #1
    Registered User
    Join Date
    03-31-2021
    Location
    As, Belgium
    MS-Off Ver
    O365
    Posts
    6

    Default in Validation List which uses a table range

    Hello

    I uses a data validation list to select the item i want.
    This Data Validation List is built by a table and the items in the table is a defined name so that when i insert an item to the list, this new item is automaticcaly available in the data validation list without adjusting the look-up range.
    Now i want that this validation list shows a default value.
    Can someone help me with this.
    And additional feature that i want if possible is that this default value is always shown also after that this validation is used and and and an item was chosen the previous time.

    Thanks in advance

    My best regards.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Default in Validation List which uses a table range

    Hi, how about a sample workbook?
    A default value, where should it come from?
    If you have the validation list then you have all the possible values, and if you select that cell where should the value come from?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. [SOLVED] VBA Possibly: Searchable list while using data validation through a named range in a table
    By AMoreno in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-03-2019, 10:47 AM
  2. [SOLVED] set a default value in dropdoen list data validation
    By aparunkumar in forum Excel General
    Replies: 5
    Last Post: 04-07-2017, 11:37 AM
  3. Data Validation list from table range
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-16-2017, 10:03 PM
  4. [SOLVED] Data validation list in a table, reference a named range on another worksheet
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-01-2017, 11:24 AM
  5. [SOLVED] Setting default value in Data Validation List
    By frenurks in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2015, 01:05 PM
  6. Data validation list, created from a filtered table range/column
    By Confuselocated in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2014, 11:28 AM
  7. [SOLVED] How to force a Default sort for a validation list
    By scott56hannah in forum Excel General
    Replies: 0
    Last Post: 04-17-2006, 10:10 PM

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