There is a limit to the size of some of the strings. I stopped getting this error when I limited the size of the ScreenTip to 254 characters.

If you delete and recreate you will get a runtime error of 1004. So depending on which method you use you will get different errors.