Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » VBA » debugging (RSS)

Browse Site by Tags

Showing related tags and posts accross the entire site.

  • How to determine if a cell has a comment

    Hi all, Can anybody tell me how to find out if a cell has a comment attached with it. Using VBA,:- Msgbox activecell.comment.text works ok providing that the cell has a comment. If it hasn't, run-time error 91 is generated. Thanks for any help. John
    Posted to VBA (Forum) by Anonymous on Wed, Feb 20 2008

  • 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...
    Posted to VBA (Forum) by Anonymous on Fri, Jan 11 2008
Page 1 of 1 (2 items)
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.