Excel-VBA Limits

These are some limits I found during my work in Excel-VBA

For more of Excel limits, see this post in Excel Functions XLFxs.com/Excel Limits


Public

Tested

My Own Work
1- User form size - buffer, see attached screen
The main limit I was facing is that the Userform has a buffer limit of ~1mb
Default buffer is set to 32k, and you will need to increase it in case you have too many controls, as you might expect I have seen.

Other limitations:
2- 10,000 chars limit in column 2 in listbox VBA in Excel

Views 97 Downloads 26

VBA-Excel Sessions
ANmarAmdeen
695
Attachments
Revisions

v2.0