Good day,
I have created a table, added columns and added formulas and all works perfectly. I then want to add an ifstatement where if the the one field contains a value and the other a certain value, then it should then give me a msgbox.
However, this step fails and I cannot seem to find how to reference to a table correctly when doing the if statement.
CrData is worksheet CrTbl is my table name
If CrData.Range("CrTbl[Association]") = "5" And CrData.Range("CrTbl[Product]") = "0" Then
MsgBox ("New Products found")
End If
Do I need to state any variables for this?
Aucun commentaire:
Enregistrer un commentaire