UserForm ComboBox ONLY display selected items in List

Hi all,

I hope you can help.

How can I create a ComboBox on a UserForm to dynamically display only the selections in a list based on a TRUE/FALSE criteria?

I have a list called Equipment on my List sheet that pulls through to a ComboBox called cbxEquipment on my UserForm1. I would like the cbxEquipment only to display the items in the List where column B of that specific item is TRUE (I created a simple check box for selection).

I have attached my workbook.

Please note: to create a new record via the userform, click on the UserForm button on the List sheet, type in a random number in the ID field and follow prompts.

Thank you in advance!

For example like this:

Please Login or Register  to view this content.

You put it in UserForm_Initialize event. If will have any further problems please do not hesitate to contact.