lock one cell when data in another
 

You can do it by formula using data validation without the
need for VBA
data|validation| use the drop down to select Custom
in the formula box enter =if(g15<0,0)
then add a message that you want displayed

dave


-----Original Message-----
OK here's the scenario I need:

When User enters data in G15, I15 needs to prevent entry.
If User clears data in G15, I15 needs to allow entry.

I know this is easy but I'm still learning VBA.
.

lock one cell when data in another
 

OK that works great!

now how about having no data entry capability in cell G15
or I15 if cell C15 is blank

TIA

-----Original Message-----
You can do it by formula using data validation without
the
need for VBA
data|validation| use the drop down to select Custom
in the formula box enter =if(g15<0,0)
then add a message that you want displayed

dave


-----Original Message-----
OK here's the scenario I need:

When User enters data in G15, I15 needs to prevent
entry.
If User clears data in G15, I15 needs to allow entry.

I know this is easy but I'm still learning VBA.
.

.