Hi,

You have put comboboxes on your sheet instead of on a userform. You will need to click on the combobox and then on Properties to get to the On_Change property. You need to trap the On_Change event to test if it is Yes or No.

I believe what you are trying to do is possible but there are much easier ways to accomplish a survey form.

How about not using comboboxes and simply do validation cells. Then test the cells for values on them changing and then move the selected cell depending on the answer. This would be a much easier way and not need Userforms or ComboBox (Shapes) controls.