title: Excel form object limit? Compile Error out of memory
body: <p>I have created an excel sheet that opens a form but I seem to have hit an object limit of some kind. I say this because with no other code changes, if I add a few more text boxes it will no longer opens and I receive compile Error out of memory. </p>
  
  <p>I have seen multiple posts about out of memory where the advice is given to use "set object = nothing". However I don't believe this will help in my case because I am not using ANY global objects and all my pvt sub variables are integer, byte, or currency. As I understand it, all private dimensions should be terminated by VBA garbage collector at the end of the function anyway.</p>
  
  <p>I exported my form1 and it shows UserForm1.frx as 4,143KB and UserForm1.frm as 140KB. </p>
  
  <p>Did I indeed hit some cap? How can I confirm that?
  Is there a way to get more out of excel since this appears as a memory limit? 
  If I am at a cap, does visual studio professional have a higher cap than excel for forms? </p>