Lock Cell based on another cell's value!

[Gowander1]

Hi,

I'm fairly new to Excel and this forum in particular. I am working on trying to restrict a users ability to input a number in a cell if the value of a different cell is above a certain amount.

For example, if the value in cell "A1" is > $150K, then the user should not be able to input a value in cell "B1".

I have looked around different postings, and am unable to find what I need. I am a beginner at VBA, so have difficulty with tweaking code written to solve other problems. I don't understand when to use "SelectChange", "Change", or "Worksheet", etc.

Thank you in advance for your help.

Regards,
Michael

[barryleajo]

Hello Michael
Welcome to the forum.
Something like this should give you the idea.
The code is in the Selection_Change event of the Sheet that is changing i.e. Sheet1 in this case.
This event generates an in-built variable called Target which is the address of the cell being changed/clicked.
This can be trapped/tested with code.

Please Login or Register  to view this content.

barry

[Gowander1]

Thank you very much Barry,

I ended up using a "Data Validation" which was sufficient for our needs this time around, but your response did the trick that I had been searching for all afternoon.

[barryleajo]

Many thanks and glad you are sorted.
Would you please mark this thread as SOLVED