+ Reply to Thread
Results 1 to 6 of 6

Sort Combobox list alphabetically

  1. 06-13-2015, 12:08 PM #1
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    596

    Sort Combobox list alphabetically

    Hello,
    I am running this Combobox:

    Please Login or Register  to view this content.
    I want to have the Combobox list displayed in alphabetical order, not in the order it is in the ListFruits.

    Could anyone advise please?
    Thank you
    Reply With QuoteRegister To Reply
  2. 06-13-2015, 12:12 PM #2
    snb is offline
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Sort Combobox list alphabetically

    userform.show should not be part of the Initialize event.

    Please Login or Register  to view this content.

    Reply With QuoteRegister To Reply
  3. 06-13-2015, 12:46 PM #3
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Sort Combobox list alphabetically

    Try 
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.
    Reply With QuoteRegister To Reply
  4. 06-13-2015, 01:34 PM #4
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    596

    Re: Sort Combobox list alphabetically

    Hi mikerickson,
    Thanks for the suggestion; I copied the code into Sheet1 Code (attached);
    I am getting a Run-time error '1004';
    "Method "Range" of object '_Global' failed"
    Any idea why?
    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 06-13-2015, 01:42 PM #5
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Sort Combobox list alphabetically

    Proabably because I used the named range ListFruit and the OP says ListFruits
    Reply With QuoteRegister To Reply
  6. 06-13-2015, 01:51 PM #6
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    596

    Re: Sort Combobox list alphabetically

    Yes, Thank you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sort ComboBox alphabetically
    By Onweerwolf in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-12-2014, 10:45 PM
  2. Sort combobox items alphabetically
    By aprilapple04 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-16-2013, 03:12 AM
  3. Sort combobox items alphabetically
    By VishalGupta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2011, 01:13 AM
  4. [SOLVED] How do I sort my excel list alphabetically by last name?
    By JIMC in forum Excel General
    Replies: 2
    Last Post: 02-21-2006, 06:45 PM
  5. Sort text list alphabetically using a formula
    By paddyyates in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2005, 11:15 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1