The answer to the question above is this: when he learns that Birnam Wood is moving toward the castle. This is the point when Macbeth realized that he has been deceived by the prophecies. The prophecies were made by the witches and it was too late that he realized that he misinterpreted their words. Despite not giving up, he was still defeated by Macduff, beheaded and killed.