VBA drop down changes

[Excelnewcomer23]

Hi Guys,

I have a drop down list from cells B7:D7, which are dependent and the output is generated in cells B9,B12 & D12.

I want somehow for the output results cells (B9,B12 & D12) to become blank if any of the drop downs value changes via VBA.

is it possible to do that?

Thanks!