Tie a Message Box to Debug.Assert for Advanced Debugging

Tie a Message Box to Debug.Assert for Advanced Debugging

Placing a message box in an error trap can provide useful debugging information, but it doesn’t allow you to return to the subroutine or function to poke around and further debug the code. This version of a message box expedites design-time debugging by breaking execution if the developer presses OK:

 Private Function MyDebugMsg(ByVal aMessage _	As String) As Boolean	' This function is used for expediting 	' development	If MsgBox(aMessage, vbOKCancel, _		"OK puts you into the Error Trap") = vbOK Then		MyDebugMsg = False	Else		MyDebugMsg = True	End IfEnd Function' Sample subPublic Sub SetColor()On Error GoTo SetColorError' body of the subroutine would go here,' force an error to demonstrateError 5SetColorErrorExit:	Exit SubSetColorError:	' In an error trap place this line in addition to any	' other error handling code	Debug.Assert MyDebugMsg(Err.Description & " in SetColor")	'other error handling code	Resume SetColorErrorExitEnd Sub
Share the Post:
data observability

Data Observability Explained

June 8, 2023

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

June 1, 2023

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

May 24, 2023

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

Show More