Make Column Mandatory if another cell in same row has data in it.

I am trying to write some VBA to make a column mandatory only if there is data in a different column.

Here's my problem:

In worksheet "For Sales", If column B contains data, then make column AW a mandatory field for the associated row.

I have tried multiple different combinations of logic/code and I can't get this to work. I would like to assign this macro to a button if possible.

Any help/advise is greatly appreciated.

Thanks,

Matt

Please Login or Register  to view this content.