+ Reply to Thread
Results 1 to 7 of 7

Create a combo box in excel

  1. #1
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Create a combo box in excel

    Hello friends,
    Please guide me how to create a combo box in excel. I have created a dropdown list of districts but to select a particular district I have to scroll several times which is time consuming. I want to save my time and speed up my work so I want to create a combo box so that I can select a particular district by pressing a particular letter quickly. For example: To select Yavatmal in dropdown list I have to scroll 37 times but now I want to select it only by pressing letter 'y' only once.
    Please see the attached file.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

    Re: Create a combo box in excel

    hello,

    Try this way ...
    Insert an ActiveX component (Combobox) into worksheet and then use something like this:
    Please Login or Register  to view this content.
    Best Regards
    MaczaQ
    ---------------------------------------------------------------------------------------------------------------------------
    If you are satisfied with the solution(s) provided, please mark your thread as Solved
    If you are pleased with my answer consider to rate it. To thank someone who has helped you, click on the star icon below their name.
    - This way you will add him some reputation points ... thanks in advance.

  3. #3
    Registered User
    Join Date
    04-10-2013
    Location
    Flintshire, Wales
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Create a combo box in excel

    Mukeshbaviskar,
    Try the modified workbook you provided. It has a combo box which is filled whenever the book is opened. I have only entered some of the districts as this is only a sample of what you needed. If you look at the code in the VB editor(In the developer tab) you will find out how it is done. To find a district just start to type what you want in the combo box and it will appear like magic!
    Good luck.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: Create a combo box in excel

    Hello IGEDIT,
    Thank you for quick response with a solution. I tried it but it is not working. There may be something wrong in code please go through it and find a solution for me. Just write me in short how to use it effectively to get the desire result correctly.
    Waiting to get the solution at the earliest.
    Please provide me the corrected modified file again.
    Thanking you in anticipation.

    Regards

    Mukesh

  5. #5
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: Create a combo box in excel

    Hello MaczaQ,
    Thank you but I am unable to follow your suggestion because of my poor knowledge. please guide me more specifically in detail with a sample file.
    Thank you.

    Mukesh

  6. #6
    Registered User
    Join Date
    04-10-2013
    Location
    Flintshire, Wales
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Create a combo box in excel

    Auto Find Combo box.xlsmmukeshbaviskar,
    Try this example.

  7. #7
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: Create a combo box in excel

    Moderator has closed this threat because of repeatation. So please respond on my personal email id given below. I respect the policy of forum and want to close this threat on forum please.

    [email protected]

    I'm getting compile error 438 Please clear it.

    Mukesh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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