Object error - method failed

Hi, I am trying to make a page where
1) if a1 has a value, combobox 1,2,3,4 will be visible
if a2 has a value, combobox 5,6,7,8 will be visible, etc,
2) when combobox1's value = completed, c1's value will be 1
when combobox1's calue = inactive, c1's value will be 2, etc.

I used the following code

Please Login or Register  to view this content.

but i keep getting a "Run-time error '1004', Method OLEObjects' of object '_Worksheet' failed." and

Please Login or Register  to view this content.

will be highlighted.
Help please! Thanks in advance!

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