+ Reply to Thread
Results 1 to 5 of 5

Populate a activeX combobox from a selection of another combobox

  1. #1
    Registered User
    Join Date
    03-24-2009
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Populate a activeX combobox from a selection of another combobox

    Rusty VBA programmer needs help, been a while!!!!

    Anybody, please help... I'm having fits with getting this to work!

    What I'm trying to do is make a selection in one combobox (1). From that selection it populate the second combobox(2) with coorasponding information.

    Table example:
    Customer: Address:
    at&t Wireless 7338 Hill Street Irving, Texas
    at&t Wireless 4678 MacArthur Blvd. Grapevine, Texas
    at&t Wireless 5353 Ft Sam Houston Blvd. Houston, Texas
    T-Mobile 4343 Green street, Tampa Florida
    T-Mobile 7474 Washington St. Dallas, Texas

    ComboBox1 (cbcusname) Select customer, T-Mobile
    ComboBox2 (cbaddress) Populate all the assosiate address for T-Mobile for another selection.

    Goal is to do this with ActiveX ComboBoxs reading from a hidden sheet.

    Now I've read several posts, checked multiple websites and just can't find right solution.. Help!!!

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Populate a activeX combobox from a selection of another combobox

    Are these on a UserForm?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    03-24-2009
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Populate a activeX combobox from a selection of another combobox

    No, I was able to write this in a userform, but as a mass template decided to scrap that idea and do straight into Cells. I've got close a few time, but the second combo box would only fill one item.. I thought this was my for each loop issue... Earlier today, I delete all the code and have started over.. Trying to take it to a simple format one to another, and I still not able to get this to work...

    I pulled out every VBA net book I got trying to remember how to do this, with no luck.. Should be that hard, that's what happens when you move up within an organization, you start to lose your basic skills that gave you so much pleasure.. Had the same issue the other day with SQL, took me all day to write a simple query in sqlplus..

    If anybody has a example please share..

  4. #4
    Registered User
    Join Date
    03-25-2009
    Location
    San Jose
    MS-Off Ver
    Excel 2007
    Posts
    83

    Re: Populate a activeX combobox from a selection of another combobox

    I was able to do this on a UserForm

    Please Login or Register  to view this content.
    I set the ComboBox2 to as Visible=False to force the first selection

    Hope this helps

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,971

    Re: Populate a activeX combobox from a selection of another combobox

    Here's a sample I downloaded from the FORUM a while back, I don't have the link/author...

    dependentdropdowns.xls
    Ben Van Johnson

+ 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