Command button to reset ComboBox selection

Hi,

Could someone please help with the below?

I have 3 combo boxes that take you to the relevant product sheet when clicked upon. I’m trying to create a command button on the main screen “Sheet 1” that will clear/reset the previous selections of the Combo Boxes but not delete the actual list.

I’m having no luck with the attached code, I would be grateful if someone could take a look at my spreadsheet and advise me further.

Thank you.

Try this code.

Please Login or Register  to view this content.