Runtime error after adding a control to a working form

mabcc · Mar 21st, 2002, 03:07 PM

I've got an Excel 2000 form that was working fine and contained about 20 controls including labels, option buttons and a combo box. When I added a new control and ran the form I got the following Dr. Watson error: Exception: access violation (0xc0000005), Address: 0x6502ce01. Seems OK now that I've copied the controls onto a new blank form, but can you explain the behavior?

[ This Message was edited by: mabcc on 2002-03-21 14:09 ]

mabcc · Mar 21st, 2002, 03:46 PM

The problem is back... As mentioned previously I pasted the controls onto a new blank VBA form and after adding a few more I again encountered the same Dr. Watson error. Is there a limit to the number of controls you can have on a form?

Mudface · Mar 21st, 2002, 03:49 PM

I think there was a problem with Excel '97, but it was something like 400+ controls (!). Sorry I haven't been much help, but have you tried looking at the Microsoft support knowledge data base?

Jack in the UK · Mar 21st, 2002, 03:51 PM

Hi

Excel has linitys to everything even character in cell to number of colours you can use.. hoiw many in intrest>>>>

Take two out and run ,,, if ok put 3 different ones back in see if it trips... if so soounds like Excels limit..
BTW Limits are confusing can be number of size.....

Mar 21st, 2002, 03:51 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Excel has linitys to everything even character in cell to number of colours you can use.. hoiw many in intrest>>>> Take two out and run ,,, if ok put 3 different ones back in see if it trips... if so soounds like Excels limit.. BTW Limits are confusing can be number of size..... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 03:07 PM	#1
mabcc New Member Join Date: Mar 2002 Posts: 2	I've got an Excel 2000 form that was working fine and contained about 20 controls including labels, option buttons and a combo box. When I added a new control and ran the form I got the following Dr. Watson error: Exception: access violation (0xc0000005), Address: 0x6502ce01. Seems OK now that I've copied the controls onto a new blank form, but can you explain the behavior? [ This Message was edited by: mabcc on 2002-03-21 14:09 ]

Mar 21st, 2002, 03:46 PM	#2
mabcc New Member Join Date: Mar 2002 Posts: 2	The problem is back... As mentioned previously I pasted the controls onto a new blank VBA form and after adding a few more I again encountered the same Dr. Watson error. Is there a limit to the number of controls you can have on a form?

Mar 21st, 2002, 03:49 PM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	I think there was a problem with Excel '97, but it was something like 400+ controls (!). Sorry I haven't been much help, but have you tried looking at the Microsoft support knowledge data base?