vb中运行vba代码
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't interested in and/or not all of the procedures that led up to arriving at the break point. Adding
当试图找出VBA或VB6中的问题的原因时,了解在错误发生之前执行了哪些过程通常很有价值。 您可以为此使用调用堆栈,但是它通常不足,因为它可能显示您不感兴趣的过程和/或不是导致到达断点的所有过程。 新增中
Debug.Print statements or MsgBox statements in procedures is another way but adding them manually can be very tedious. The add-in I've attached resolves those problems by automatically adding statements in all selected procedures that contains "Debug.Print" or whatever else you want along with the name of the procedure.
过程中的Debug.Print语句或MsgBox语句是另一种方法,但是手动添加它们可能非常繁琐。 我随附的外接程序通过自动添加来解决这些问题 所有选定过程中包含“ Debug.Print”或任何其他所需语句以及过程名称的语句。
When the add-in is loaded this toolbar will be added to the Visual Basic IDE in VB6 or the VBE (Visual Basic Environment) in Excel.
加载加载项后,此工具栏将被添加到VB6中的Visual Basic IDE或Excel中的VBE(Visual Basic环境)中。