+ Reply to Thread
Results 1 to 4 of 4

Loading combo boxes depending on others

  1. #1
    Forum Contributor
    Join Date
    03-16-2009
    Location
    NC
    MS-Off Ver
    Office 2016
    Posts
    164

    Loading combo boxes depending on others

    Hi,

    I have in a user form 2 combo boxes. In one of my sheets I have the data that I want to be loaded in the combobox depending on the other combobox.
    In other words if combobox1 = white, then combobox2 needs to have the following items to be picked from "large", "medium", "small". If combobox1 = "blue" then I combobox2 needs to have another 4 items and so on. I have about 8 different options in combobox1.

    What code could I use on that?

    Also in that same project, I have a spreadsheet that has all my data; such as a inventory. How can I do, when I pick the SKU# to load the other fields, such as Description, qty on hand, price, etc?

    Thanks!

    Thanks for all the help
    Last edited by sentinela; 04-28-2009 at 08:27 AM. Reason: Solved

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

    Re: Loading combo boxes depending on others

    Check this out, it might be of some help.

    GL!
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-16-2009
    Location
    NC
    MS-Off Ver
    Office 2016
    Posts
    164

    Smile Re: Loading combo boxes depending on others

    D3Pratt

    That's it... Great example. That's what I needed.

    A big thanks!!!

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

    Re: Loading combo boxes depending on others

    Happy to help


+ 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