Speaking from personal experience:

Your family has done enough.  Only he can decide if he wants to kick the addiction.  Tell him he's now on his own.  Let him go and prepare yourself for the worst.

In the end it is his fight to win or lose.  In my case the family member eventually chose life.