R
Ripan
I have created a relatively large data entry tool using Excel'
userforms. I have developed this tool using Windows 2000 and Exce
2002.
Upon opening the workbook, I automatically have a main form show whic
allows the user to open or edit an existing file. When a file i
opened, a large (almost 200+ controls form in a 10-page multipage) i
loaded and opened. I have noticed the following problem:
On windows XP, if I save the workbook and close Excel, then open th
workbook and try to open the form, which is done by first using th
Load command and then the show command, Excel crashes (Screen where yo
are given the option to send error report).
Interestingly enough, if a breakpoint exists in the code to load th
form, there is no crash.
Has anyone encountered this type of error using the Load command wit
large forms?
Any help or follow-up questions are appreciated.
Ripa
userforms. I have developed this tool using Windows 2000 and Exce
2002.
Upon opening the workbook, I automatically have a main form show whic
allows the user to open or edit an existing file. When a file i
opened, a large (almost 200+ controls form in a 10-page multipage) i
loaded and opened. I have noticed the following problem:
On windows XP, if I save the workbook and close Excel, then open th
workbook and try to open the form, which is done by first using th
Load command and then the show command, Excel crashes (Screen where yo
are given the option to send error report).
Interestingly enough, if a breakpoint exists in the code to load th
form, there is no crash.
Has anyone encountered this type of error using the Load command wit
large forms?
Any help or follow-up questions are appreciated.
Ripa