 |
|
|
|
|
|
Back to: Excel VBA . Got any Excel/VBA Questions? Free Excel Help
Sub NoAlerts() Application.DisplayAlerts=False 'Your code here! Application.DisplayAlerts=True End Sub
Stop all Run Time Errors:
SubNoRunTimeErrors() On Error Resume Next 'Your code here! 'Reset Run Time Errors On Error GoTo 0 End Sub
Display your own Run Time Errors:
Sub MyMacro() On Error Goto MyError 'Your code here
Exit sub MyError: MsgBox Err.Number & " " & Err.Description End Sub
Debug code 1:
In the Code Window, right click on the "Margin Indicator" (grey bar to left
of Code Window) to insert a Break point or push F9 (toggles Break
point). Push F5 to run macro, push F8 to step through code. Hover
mouse insertion point over variables and code to see values. Drag the yellow arrow
to skip lines, or repeat them.
Debug code 2:
In the Code Window, right click on the "Margin Indicator" (grey bar to left
of Code Window) to insert a Break point or push F9 (toggles Break
point). Go to View>Locals Window and push F5 to run macro. Push
F8 to step through code. All your variables will automatically be placed in
the Locals Window, showing the Expression, Value and Type.
I can also highly recommend this Microsoft link on
Trappable Errors in Visual Basic for Apps as very good indeed.
Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS