jeudi 25 août 2016

If statement reference to table VBA

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