+ Reply to Thread
Results 1 to 4 of 4

Populate 2nd combo with alpha based on 1st combo with 2 columns of numeric codes

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    80

    Populate 2nd combo with alpha based on 1st combo with 2 columns of numeric codes

    Ok, here is the challenge. I have 3 combo boxes. The first I populated with regional institutions. The second is for districts in that region, but I only have numeric codes at the moment. Lastly, the 3rd combo box will display the name(s) of local institutions in that district. It seems to me I would create a loop based on the district code in combo #2. The kicker is if the user does not make a selection( in #2 or #3) they get everything for combos #2 and/or #3 (default values). I honestly am racking my brain in how to even approach this since I'm new to vba programming. The first combobox only has 57 unique values. So that was easy enough to code. The rest however...

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Populate 2nd combo with alpha based on 1st combo with 2 columns of numeric codes

    How is the data organised?

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-09-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    80

    Re: Populate 2nd combo with alpha based on 1st combo with 2 columns of numeric codes

    Column 1 is the district code(5 digits), column 2(5 digits) is the building code and column 9 is the name(aplha varies). The name column is mixed with all 3. The first 57 values are combobox 1 so that's done. The rest have to be filtered. does that help? The spreadsheet is on a different computer not on the network here at work.

  4. #4
    Registered User
    Join Date
    07-09-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    80

    Re: Populate 2nd combo with alpha based on 1st combo with 2 columns of numeric codes

    I was able to find some code to take care of combobox 1, but that's it. I knew the coding of #2 and #3 would be complicated.
    Last edited by dovermac; 07-15-2014 at 10:12 AM.

+ 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. Populate Combo box 2 based on Selected item in Combo box 1
    By Vasu_XL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2014, 07:45 AM
  2. [SOLVED] Generate a range of sequential alpha numeric codes based on a from and to value
    By kenny.fsw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2013, 09:53 AM
  3. [SOLVED] How do I populate a ActiveX Combo box with Text and a Numeric value
    By toddbailey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2012, 12:04 PM
  4. Alpha Numeric Codes
    By Caddock01 in forum Excel General
    Replies: 2
    Last Post: 07-28-2011, 12:37 PM
  5. Populate a Combo Box based on the selection of another Combo Box
    By thunder279 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2011, 03:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1