I Put a break point in VBA macro and stops at that line during execution. After that I add 3 variables to the watch window. The watch window is in undocked state. After executing one line I wanted to delete all the items in watch window. I set focus to Watch Window. To delete items, I either presses Del key or goto Edit menu and click Clear menu item. This clears one item. Then the current window focus is changed to VBA editor window where I have my breakpoint. If I press Del key again the text in the editor is got deleted. For deleting 3 items in the Watch window I could not continuously press Del 3 times. For every delete the focus needs to set back to Watch window. But If I am not in Debug break mode I am able to press the Del key 3 times to delete the watch items without changing focus. Please let me know, is there any option to resolve this. I wanted to delete all the items without manually reset the focus every time. Thanks in advance
-Regards Santhakumar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
