Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Debugging with "data tips"

Latest post Fri, Jan 11 2008 11:59 AM by Nick Hodge. 1 replies.
  • Fri, Jan 11 2008 8:33 AM

    Debugging with "data tips"

    In Excel 2000 when debugging VBA, at a break point I could hover with the cursor over a variable name and a popup box, which Microsoft calls the "Data Tips", would appear showing the current value assigned to the variable.

     In my current situation using Excel 2003, the data tips do not appear while hovering over a variable during a break. I have checked the Tools, Options settings and both Auto DataTips and Show ToolTips are checked, but the tips still do not appear.

     

    I found Nick Hodge's name in an old forum doing a Google on the problem and emailed him. He suggested I post here with the bit more elaboration I have provided.

    Filed under: , ,
    • Post Points: 21
  • Fri, Jan 11 2008 11:59 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 336
    • Points 5,771
    • MVP

    Re: Debugging with "data tips"

    Anonymous

    The setting that should be checked is Data Tips. The tool tips one is just for the toolbar button tooltips. I would try first unchecking, closing excel, opening Excel and re-checking to see if that fixes it.

     After that I would try a detect and repair under the help menu, you may find that a service pack or something has screwed a registry setting.

    If that fails post back and we'll see if there are any other suggestions

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK

    Filed under:
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.