Dependent lists using data validation or comboboxes

    Hi,
    1. I have placed couple of Combox boxes with Activex control.
    2. I have linked the cells to display "OJT" and "P2P" in cobo box 1.
    My Question
    3. If i select "OJT" in combo box1 it has to load "Windows" "Intel" "VMware" in combo box2.
    4. If i select "P2P" in combo box1 it has to load "Incoming" "Storage" "WebLogic" in combo box2.
    How can i do this..I am using MsOffice 2010.

    Re: help with Cobo boxes in Excel 2010 + VB


    I would use data validation rather than comboboxes.


    Create named ranges for the lists then add data validation to a cell for the 'OJT & P2P' in the next cell use this in the refers to box of data validation =INDIRECT($A$1)


    Windy

    Re: Dependent lists using data validation or comboboxes


    sbrajagopal7,


    Did you read the forum rules? I guess not . . . otherwise you would have known that cross posting is a rule violation.
    Per the rules you agreed to abide by you must include links to *ALL* other forums where you have posted this same question.


    Click on "[COLOR="#FF0000"]Message to Cross Posters[/COLOR]" in my signature to understand why all Excel forums have this rule about cross posting.


    Regarding thread titles - note the change to your thread title. Titles should accurately describe your thread. Please avoid the use of abbreviations (Cobo) and any non-essential verbiage that dilutes the title.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login