Adding code to a control on a form causes excel to crash

[Guest]

Good day folks,

I have a form which shows the user information which has been entered
previously and asks for new user input.

The form worked fine until I added some new controls and added the code to
populate the combo boxes which a few choices.

I put a stop in the code and stepped through to see what the problem was and
it ran fine until it got to the new code. When it gets to the first line of
the new code excel crashes every time.

I have tried deleting the controls and starting again by adding them to the
form and I have tried using a new form - both cause excel to crash....
Is there a memory limit that I'm reaching? The entire spreadsheet only
weighs in at 1mb so surely not?

Any advice on how to solve this issue?

Thanks a lot

 

[Tom Ogilvy]

I don't believe a memory limit is the source of your problem.

You might try Rob Bovey's free code cleaner addin
http://www.appspro.com