Macro to reset combo dropdown box

[sun815613]

Hi,

I've tried what I can and my head hurts. I'm sure it's something straightforward but can someone please kindly look at the attachment and program the button to reset the dropdowns to blanks in one simple click?

Regards,
Sunil.

[DBY]

Hello
See the attachment. The macro clears the contents of K3 and K8 which in turn clears the drop down boxes. Hope this helps with the headache.

[sun815613]

Excellent stuff, thank you! That's eased the headache. I was trying to physically clear the dropdowns whereas I just needed to clear the cells! Thanks again.