MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Old Lotus Macro Guy Problem

Posted by DHall on November 01, 2001 3:55 AM

I found the Lotus macro debugging feature handy, where you could watch the spreadsheet screen and see your code being executed at the same time.

Does anyone know if this is possible with Vba?


Posted by Damon Ostrander on November 06, 2001 11:20 AM

Hi DHall,

If you are familiar with the debugging capability of the VBE, simply move/size the VBE window on the screen so that you can also see the Excel window as you step through your code. If you are not familiar with VBA debugging, in the VBE go to View -> Toolbars -> Debug. The use of the debugging features provided by this toolbar are mostly obvious. It's one of the better debugging environments I've used--and I've used quite a few in developing with different languages.

Happy debugging.