alanchinese
03-03-2009, 01:08 PM
I have been maintaining an excel vba program.
In the beginning, I had one large module. It breaks frequently. I found out some suggestions that the exported module size should be below 64k. Therefore, I splited the codes into multiple modules, making sure that each one is smaller than 40k.
However, as more controls were added to the form, it's size gets larger and larger. Now I have 450 controls. For some reason, the vba fails to access some of the newer controls (textboxes). If I commented out those lines, if will still fail in some other new controls.
Does VBA form has the limitation of number of controls? How do I resolve the form size issues?
The message I have always seen says, "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." "The information you were working on might be lost. Microsoft Office Excel can try to recover it for you". It only appear during run-time and it's really INCONVENIENT!!!! Please help!
In the beginning, I had one large module. It breaks frequently. I found out some suggestions that the exported module size should be below 64k. Therefore, I splited the codes into multiple modules, making sure that each one is smaller than 40k.
However, as more controls were added to the form, it's size gets larger and larger. Now I have 450 controls. For some reason, the vba fails to access some of the newer controls (textboxes). If I commented out those lines, if will still fail in some other new controls.
Does VBA form has the limitation of number of controls? How do I resolve the form size issues?
The message I have always seen says, "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." "The information you were working on might be lost. Microsoft Office Excel can try to recover it for you". It only appear during run-time and it's really INCONVENIENT!!!! Please help!