I'm quite new to VBA and I'm trying to reset a cell after deleting the input. The code seems to work until I write it with an If formula. Can someone maybe help me or point me in the right direction?
Sub Worksheet_SelectionChange(ByVal Target As Range)
If Worksheets("GeneralData").Range("C26").Value = False And Range("A14") = "" Then
Range("A14").Formula = "=IF(GeneralData!$G$9<0;"";GeneralData!$G$9)"
End If
End Sub
Aucun commentaire:
Enregistrer un commentaire