+ Reply to Thread
Results 1 to 3 of 3

Combobox issues: alphabetizing and searching while typing

Hybrid View

  1. #1
    Registered User
    Join Date
    08-27-2014
    Location
    Albany, NY
    MS-Off Ver
    Office 2010
    Posts
    91

    Combobox issues: alphabetizing and searching while typing

    I was hoping that I could alphabetize the combo box named "FacNameCombo" on userform5. I can do the other forms but I can't figure out how to work this one since it pulls the info in, in a loop.

    Second if there is any way to predictive type search a combo box, that would be epic!
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Combobox issues: alphabetizing and searching while typing

    I added a sort routine to Module one to handle ANY list control that needs sorting.

    I moved the facNameCombo_change code to an Exit event.

    I had to replace the combobox with a fresh one to bring back predictive typing.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    08-27-2014
    Location
    Albany, NY
    MS-Off Ver
    Office 2010
    Posts
    91

    Re: Combobox issues: alphabetizing and searching while typing

    ehr merh gawd....thank you.

    In all seriousness this not only was a huge help but I have been looking at the code and I can learn alot from it . 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. Vlookup and combobox issues
    By Charles1104 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2012, 12:02 PM
  2. Combobox Populating via a list or directly typing
    By nighttrainrex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2011, 05:03 PM
  3. Issues with the searching all Excel Files
    By Jrider85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2008, 06:55 AM
  4. combobox issues
    By wahoodude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2007, 06:30 PM
  5. [SOLVED] ComboBox Issues
    By Darrin Henshaw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2005, 09:08 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