---

Excel VBA Runtime Errors & Preventing Them

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 F8to step through code. All your variables will automatically be placed in the Locals Window, showing the Expression, Value and Type. 

 

See also:

Excel VBA: Does Cell Have Formula

Excel VBA Macro: Determine Which Button, Control or Command Button Was Clicked

Excel VBA: Macro Code To Run Macros On Protected Worksheets & Sheets

Excel VBA: Stop Screen Flickering in Recorded Macros and Speed up Your Code

Excel Ranges: Finding the Last Cell in a Range

Excel: Get File Name From User to Open Workbook Or Save Workbook

 

See also: Index to Excel VBA Code; Index to Excel Freebies; Lesson 1 - Excel Fundamentals; Index to how to… providing a range of solutions

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

Gallery

---

• 
• 
• 
• 
• 
•