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.
.
.
|