Hello,

I'm over my head on designing a userform that's intended as a data entry tool for collecting building materials found in a single house. It's not intended to collect data on more than one house. Using the list of building materials in Sheet 1 the operator will select the material from two comboboxes. Group1 Combobox2 is populated by materials dependent on Group1 Combobox1. Names of the combobox mirrors the column on the sheet. The unique feature of all this is that Group1 combobox is triggered by the operator selecting a Multipage tab. For this sample, selecting Multipage 2 / Page4 "Wall Covering" will filter materials in Sheet 1 "Wall Coverings B18:B39"

When all comboboxes are filled the operator will enter a value in Textbox 1 ie 100% This value should be entered in the respective control source cell in the spreadsheet.

Notice I did not include an "Add" command button. This is intentional.

Anyway, your opinion on this userform design is appreciated and any help with the coding is off course indebted with gratitude.

Gal

Userform 6.0.xlsm