for my Curiosity, What are the difference between the Onerror and Iserror functions.
The simple answer is that the IsError function exists and OnError doesn't
You may be getting confused with error handling in a procedure.
For example:
Code:
Sub ClearData()
On Error GoTo Err_Handler
Dim intC As Integer
For intC = 1 To 30
Me("L" & intC).Caption = ""
Me("Bar" & intC) = ""
Me("L" & intC).visible = False
Me("Bar" & intC).visible = False
Next intC
Exit_Handler:
Exit Sub
Err_Handler:
MsgBox "Error " & Err.Number & " in ClearData procedure: " & Err.Description
Resume Exit_Handler
End Sub