1. Select sheet "names and blends", sort the Materials column to delete blank rows.
2. Select rom row 2 to the bottom of the list and type a name such as "MaterialsList" in the name box on the formula bar.
3. Select Developer ribbon, Design Mode:
4. For each combobox, right click, select PROPERTIES
a) ListFillRange --> "=materialslist"
b) Linked Cell --> the cell the box is sitting on