Insert formula and can enter number in the same cell

[fdecmc7]

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

[alansidman]

Based upon your description, the following will do exactly as asked.

Please Login or Register  to view this content.

[fdecmc7]

Hi,
I just wondering why there is run time error 13 in this coding? however is still working.,

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$L$29" And Target <> Chr(yes) Then
Range("O29,Q29,S29") = ""
End If
End Sub

Thanks

[protonLeah]

Chr() Function: Returns a String containing the character associated with the specified character code.

"yes" is not a character code.

Please Login or Register  to view this content.