In your VBA Editor, in the "Tools --> Options", "Auto Data Tips" should be checked. If its stopped working for no reason, then this may not help but its worth a try. If that doesn't work, you may have to try reinstalling. You might be able to just reinstall the VBA Editor, I am not sure.