mardi 4 mai 2021

vba write if formula into cell not working [duplicate]

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