+ Reply to Thread
Results 1 to 4 of 4

Data Validation drop down list View.

  1. #1
    Registered User
    Join Date
    05-18-2017
    Location
    Canberra
    MS-Off Ver
    2016-365
    Posts
    22

    Data Validation drop down list View.

    Hi All
    i am using a number of Data validation lists and when i click on the list the little window that shows list is not large enough to see what each line says. is there a way to make list larger.
    i would also like to make the list longer if possible.
    Code i am using =INDIRECT("'WHS Folio'!"&"$"&CHAR(CODE(LEFT(H123,1)))&"$2:$"&CHAR(CODE(LEFT(H123,1)))&"$25")
    each item in the list is about 100 caricatures long.
    any ideas
    kind regards
    Mark

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Data Validation drop down list View.

    If you made the list on the sheet, then reference the list in the DataValidation List.

    Select The range
    Name the range in the Range Name box
    Use that name as the data validation list.

    Here's an Image

    Data Validation List.jpg

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Data Validation drop down list View.

    maybe you need to read up about combo boxes....
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Registered User
    Join Date
    05-18-2017
    Location
    Canberra
    MS-Off Ver
    2016-365
    Posts
    22

    Re: Data Validation drop down list View.

    Hi Dave, Glenn
    thank you so much for the reply.
    with the list it is about being able to read it before you make the selection. so making the drop-down window larger. funny thing is on my Mac
    it automatically fits the window to the list.

    Glenn i like the look of the combobox. can the combobox change source of list depending on what is first generated.

    cell M29 can have a value of either A-WHS, B-WHS, C-WHS,D-WHS,E-WHS.
    Cell N29 provides a different list depending on what is in M29

    thank you for your time and help.
    kind regards
    Mark

+ 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: 3
    Last Post: 07-05-2015, 12:45 AM
  2. Replies: 0
    Last Post: 04-24-2015, 02:27 PM
  3. Replies: 5
    Last Post: 03-26-2015, 01:40 PM
  4. Drop Down List (Data Validation) Need to start at current value in list
    By bigmantitus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2014, 11:14 AM
  5. Data validation List: A macro to initiate drop down list?
    By dchubbock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2013, 08:12 PM
  6. Replies: 1
    Last Post: 09-05-2012, 11:39 AM
  7. Replies: 1
    Last Post: 07-08-2005, 11:05 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