I have a small question
How to test in VBA if a field contains a specific text at the end?
In Excel i would use : =Right(field;5)
How to evaluate in aVBA IF statement those 5 last chars ?
I tried several options but got errors all the time.
In general how to use a Excel function in VBA...