Hi

At what point in the loop is it failing? First run through? When it fails, do a debug and see what is in the strings (comboboxname, comboboxname2...). Do these comboboxes exist?

If it is failing on the first loop, then build an example file that matches your structure, with the comboboxes etc. Remove any sensitive data, but make the dummy data representative of your data type.

I just took your code for the worksheet change event, put 4 comboboxes from the controls toolbar on the sheet and stepped through it for the first iteration and there were no problems.


rylo