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 [email protected] 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
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates