Userform limit

[Coolmo]

Is there a limit to how many userforms one VB program can have? just curious because I have a big 'ol master VB program that launches a ton of other "programs" (different userforms) and was wondering if I'll hit a limit some day... or if this will eventually slow things down.

[Ed Jobe]

I'm not aware of any such limit, other than memory. If you run into a problem later, you can break your project up into smaller projects.

[rkmcswain]

Agreed.

Also, in case you don't know about this..... Be sure to open VBAMAN periodically, and run a SaveAs on your DVB file. The file size should be much smaller.

[Ed Jobe]

The file size should be much smaller.

Temporarily. Doing SaveAs only strips out the compiled code, saving the ascii portion known as pseudo code. As soon as vba compiles it again, the size will be similar to before the SaveAs.

[Coolmo]

Is that why when I take my VBA program home to work on it, overwriting what was done the previous night, the file size seems to flop around from large to small and then back again? i'm constantly adding stuff to the program so it should only be getting bigger. I figured it had something to do with the different computers I was running and saving it on from one place to the other.

I also assume by "ascii portion" you mean the "stuff" we actually type into the code portion of the program? I didn't know it added other compiled "stuff".

[rkmcswain]

Temporarily. Doing SaveAs only strips out the compiled code, saving the ascii portion known as pseudo code. As soon as vba compiles it again, the size will be similar to before the SaveAs.

Not exactly.

I have a 4.9MB DVB file.

After a SaveAs, the size goes to 1.9MB.

After a compile of that 1.9MB version, then a save, the file size is 3.6MB - so it still shed 1.3MB of something, somewhere.....

[Ed Jobe]

Other things can affect it, e.g. the controls you use.

[rkmcswain]

Other things can affect it, e.g. the controls you use.

True. That was my only point. That a periodic "SaveAs" can sort of "purge" your file....

[Ed Jobe]

Yeah, I wouldn't expect anything dramatic though. Sometime people propose that and they don't go back later to check the filesize, not realizing that compilation takes place.