VBA to automatically unhide columns based on a specific dropdown selection

[AshKate]

Hello!

I am in need of a VBA that automatically runs if a user on my worksheet chooses a specific dropdown value.

I would like Columns X and Y to automatically become visible only if a color code "Black" is selected from the dropdown in Column W. With all other values (Green, Blue, Purple, Orange, Yellow, Red) Columns X and Y can remain hidden as the information isn't relevant then.

I would greatly appreciate the help. I am slightly new to VBA and have spent hours looking for what I need but cannot seem to piece it all together.

Thank you,

Ashley

 

[Michael M]

glad to help.....
I was concerned that by having as I described in a previous post, that the code would always fail !!.....