• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

ActiveX ListBox to be populated

ajoshi76

Member
Hello

Request your help in getting the ActiveBox ListBox populated based on 2 Validation lists and reference data in another sheet using Macro

1. Select Application Name
2. Select Feature Name
3. CLick on the Refresh Button - Populate the ActiveX ListBox based on 1. and 2. and Reference Data on another sheet.

Attached please find the working file.
 

Attachments

Hui

Excel Ninja
Staff member
It is really not clear what result you want?

Can you expand the description

If you just want to do a lookup, on sheet: Form II, type the following anywhere
=INDEX(AFC[Component Details],MATCH(G6&L6,AFC[Concatenate],0))
 

ajoshi76

Member
It is really not clear what result you want?

Can you expand the description

If you just want to do a lookup, on sheet: Form II, type the following anywhere
=INDEX(AFC[Component Details],MATCH(G6&L6,AFC[Concatenate],0))
Hello Hui
The output (components) should be displayed in the Activex Listbox. based on Application and Feature combination.
 
Top