====== Error handling ======
===== Cathing errors =====
In all subs and function you should use a error handler. This error handler catches errors and allow you to show the error and stops the Vba from breaking down.
=== Code example ===
Private Sub GetValue()
On Error GoTo ErrorHandler
'Write your code
Exit Sub
ErrorHandler:
Call UI.ShowError(“Actionpad_Company.GetValue”)
End Sub
===== Best practice =====
To avoid errors to even happen it could be a good thing to check for general errors.
=== Use If statements to avoid using objects that is Nothing ===
If Not oMyObject Is Nothing Then
' Do my magic stuff with the object
Else
Call Lime.MessageBox("Message to user")
End If