Restricting cell inputs based upon another cells contents

[macca_18380]

Hi and thank you all again in advance!

How would i restrict entry of any data into a cell in VBA based upon the contents of another cell?

For example, if cells A1:A10 contains "YES" or "NO" then how do i restrict a row of corresponding cells in cells B1:B10 from having any data entered?

Thank you again!

Best regards
Michael

 

[dreid1011]

You can do this with data validation.
Notice the message after trying to enter a value into B3:

You can use a rule similar to this:

Unless you absolutely have to use VBA...

 

[macca_18380]

That's amazing, i did wonder if you could use data validation, thank you so much!

 

[dreid1011]

You're welcome, and happy to help.