• 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

  • ActiveX POpulate.xlsm
    57.6 KB · Views: 4
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))
 
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.
 
Back
Top