Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOCK CELL AFTER DATA IS ENTERED | Excel Discussion (Misc queries) | |||
Lock the cell once enter the data | Excel Worksheet Functions | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
Lock Data in Cell after entered | Excel Discussion (Misc queries) | |||
Lock Cell After Data Entry | Excel Discussion (Misc queries) |