VBA调试器仅显示集合的256个元素 [英] VBA Debugger shows only 256 elements of a collection

问题描述

标题说明了我的问题。我正在研究excelmakro和
，我的问题是，调试器是否可以像显示数组那样显示所有元素？

the title explains my problem. Im working on an excelmakro and my questions is, is there an option that the debugger shows all elements like it does with an array?

是在使集合膨胀后将我的类对象存储在数组中的唯一解决方法？

And if not, is the only workaround the storage of my classobjects in an array after inflating the collection?

感谢您的帮助。

推荐答案

您可以使用 debug.print 并将输出写入立即窗口并以这种方式绕过限制。

You could use debug.print and write the output into the immediate window and bypass the limit that way.

我几乎可以肯定没有办法提高该限制，但是也许其他人可以给出一个定义。答案。

I am almost certain that there is no way to increase that limit, but maybe someone else can give a def. answer on that.

这篇关于VBA调试器仅显示集合的256个元素的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！