dropdown list in alphabetical order data validation...
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: dropdown list in alphabetical order data validation...

  1. #21
    Board Regular albertc30's Avatar
    Join Date
    May 2012
    Location
    Norfolk
    Posts
    969
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: dropdown list in alphabetical order data validation...

    Okay.

    I have come across this;

    When you let the dynamic named range change, you should use VBA to re-set the .ListFillRange such that the combobox will refresh its list-items.

    No clue as to how though!
    Many thanks for all the help, much appreciated.

    Regards,
    Albert

    Reminder
    Remember to use code tags people.

  2. #22
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    1,972
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    4 Thread(s)

    Default Re: dropdown list in alphabetical order data validation...

    Quote Originally Posted by albertc30 View Post
    Okay.
    When you let the dynamic named range change, you should use VBA to re-set the .ListFillRange such that the combobox will refresh its list-items.
    !
    As a start you may find this link helpful (it's about a searchable combobox):
    https://www.mrexcel.com/forum/excel-...selection.html

  3. #23
    Board Regular albertc30's Avatar
    Join Date
    May 2012
    Location
    Norfolk
    Posts
    969
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: dropdown list in alphabetical order data validation...

    Quote Originally Posted by Akuini View Post
    As a start you may find this link helpful (it's about a searchable combobox):
    https://www.mrexcel.com/forum/excel-...selection.html
    Very interesting.

    It doesn't sort list in alphabetical order.

    I will give it a go but need to wrap my head around this one.

    Will have to create a back at this point.

    Cheers.
    Many thanks for all the help, much appreciated.

    Regards,
    Albert

    Reminder
    Remember to use code tags people.

  4. #24
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    1,972
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    4 Thread(s)

    Default Re: dropdown list in alphabetical order data validation...

    Here's another version that make the list in the combobox unique, sorted & not having blank:

    https://www.dropbox.com/s/vwdihz6imn...list.xlsm?dl=0

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •