Clear Contents, Independent Instances; Separate Worksheet VBA

It's me again...

So to explain I have a series of 15 sheets.
Each sheet provides it's own references, dynamic ranges and so on.
I have provided an "Options" Tab. But, this by no means where all selections and fields are filled in.
I have a number of options on the Options tab, that I need to change corresponding cell in Sheet1 to blank,
if the referring cell in the Options tab changes.

WORKSHEET15 (Options Tab)

Please Login or Register  to view this content.

However, I also need dependent dropdown cells in Sheet1 to clear when their source is changed in Sheet1.

Please Login or Register  to view this content.

While I am learning what all of this means; in no way do I claim to understand the breakdown or code as a whole. I have only recently started tinkering with VBA, whereas I am generally good enough with functions and data validation to cobble things together.

As always, any help is greatly appreciated.

What's your question?

How to I make both of these work in vba
Without assigning a macro.

I don't understand; those are macros, and they run automatically in response to changes on the worksheet.

Please Login or Register  to view this content.

Thanks again.

You're welcome.

I'm happy to answer any of your questions after you've invested the time to look at Help for those statements.

You're welcome.