+ Reply to Thread
Results 1 to 4 of 4

Populate a Combo Box based on the selection of another Combo Box

  1. #1
    Registered User
    Join Date
    02-17-2011
    Location
    Troy, MI
    MS-Off Ver
    Excel 2003
    Posts
    2

    Exclamation Populate a Combo Box based on the selection of another Combo Box

    I am in need of some help. I have some information on millages rates by city and then by school district. Each city has specific school districts that apply.

    Therefore, I would like to create one combo box that populates all the city/townships in it. Based on the selection you choose for that, I want a second combo box to populate which school districts apply to that specific city or township. Finally, once you choose the school district, I want to display the millage rate that corresponds to that school district and city/township.

    An example of what I mean:
    Macomb Township Chippewa Valley 27.5813
    New Haven 26.9313
    Clinton Township Chippewa Valley 36.2891
    Mt. Clemens 39.8418

    I've seen some previous posts about a similar problem, but I am rather new to this so any help would be appreciated.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,168

    Re: Populate a Combo Box based on the selection of another Combo Box

    Look at this:

    http://www.contextures.com/xldataval02.html

    Alan

  3. #3
    Registered User
    Join Date
    02-17-2011
    Location
    Troy, MI
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Populate a Combo Box based on the selection of another Combo Box

    Thanks Alan. I did manage to get my table to work. It was a pain however due to the length of some of the cities and getting the references to work correctly.


    Still kinda curious as how to do it using combo boxes and VBA.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,168

    Re: Populate a Combo Box based on the selection of another Combo Box

    Do a search on google "Excel Combo boxes and VBA" I'll wager you get lots of hits.

    Alan

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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