Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox cancels "Step Into" Mode!
I don't get it. I am just trying to debug a macro. So I press F8 to initiate
the "Debug - Step Into" mode, and everything is working as expected until I hit a MsgBox statement that just displays a message and an OK button. As soon as I press the OK button, VBA seems to 'forget' that I was in Step Mode and just takes off and runs the rest of the macro. Anyone have any idea what could cause this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox cancels "Step Into" Mode!
Put a break point (click on the left margin or right
click-Toggle-Breakpoint) on the line after the Msgbox line -- Chris Farkas Excel/Access Developer http://www.eAlchemy.biz "Kip Martin" wrote: I don't get it. I am just trying to debug a macro. So I press F8 to initiate the "Debug - Step Into" mode, and everything is working as expected until I hit a MsgBox statement that just displays a message and an OK button. As soon as I press the OK button, VBA seems to 'forget' that I was in Step Mode and just takes off and runs the rest of the macro. Anyone have any idea what could cause this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox cancels "Step Into" Mode!
I've never heard of that before, but the first thing I would do would be to
use Rob Bovey's Code Cleaner add-in to purge VBA's own code storage and recreate it from scratch. You can get Rob's Code Cleaner at http://www.appspro.com/Utilities/CodeCleaner.htm -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Kip Martin" wrote in message ... I don't get it. I am just trying to debug a macro. So I press F8 to initiate the "Debug - Step Into" mode, and everything is working as expected until I hit a MsgBox statement that just displays a message and an OK button. As soon as I press the OK button, VBA seems to 'forget' that I was in Step Mode and just takes off and runs the rest of the macro. Anyone have any idea what could cause this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
shortcut key to see a macro running "step by step" | Excel Programming |