Excel VBA Video Training/ EXCEL DASHBOARD REPORTS

Ozgrid, Experts in Microsoft Excel Spreadsheets

Excel VBA Runtime Errors & Preventing Them

 

Back to: Excel VBA . Got any Excel/VBA Questions? Free Excel Help

Stop all Excel default alerts:

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 VBA Video Training/ EXCEL DASHBOARD REPORTS

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