How to: Fill combobox inlcuding IF statement

[bluestarrr]

Hello Guys,

I have a question about filling a combobox. I would like to add values from collum B to the combobox. On the condition that the requirement will met the values of collum A.
For example: requirement = Beer
Collum A | Colum B
Beer | Heineken
Wine | BLOSSOM HILL
Beer | Corona
Wisky | Black label
The combobox should be filled with Heineken & Corona.

On the internet i couldn't find an example/macro, could you guys help me?!!

Kind regards,
Blue
combobox.xlsm

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[bluestarrr]

Thanks for the tip Protonleah

[protonLeah]

Try this one for a start:

Please Login or Register  to view this content.

[bluestarrr]

Thanks Protonleah that is what i needed!!!

PS. For the people who are interested I have adjusted the code a little bit. So it will only activated
while a specific cell value changes and it clears now first the combobox so it won’t fill up with old data

Please Login or Register  to view this content.