Hi, I want make if cell A1 is saying "NO" , it will delete all the value in cell B1 and if the cell A1 is saying "YES" then I can enter number in cell B1.
message edited by fdecmc7
The only way to accomplish what you want is with a macro. Formulas can't delete data and you can't enter data in the same cell as a formula without the formula going away. This macro should do what you want:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" And Target = "No" Then Range("B1") = "" End If End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.
great!! it works.. im very lack of skill in excel.. Thanks mate!!
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |