Recent content by DavidWilkinson

It turned out I hadn't solved the problem. But I am fairly certain I have now.. Rather than it being caused by the size of the code modules, the original error was certainly, or as certain as I can be, caused because I had exceeded the number of controls allowed on a User form. This limit and...

Denial, I recently came across the following URL which refers to Visual Basic Code limitations. http://msdn.microsoft.com/en-us/library/aa240819(VS.60).aspx From what I have read (As an example): http://visualbasic.ittoolbox.com/documents/the-difference-between-vba-and-visual-basic-11956...

I believe I have finally solved the problem. As a last resort, I rebuilt the form by hand, control by control into an empty workbook. I then only imported the form – not the code associated with the form, because there wasn’t any – into the version that failed and the versions I have created...

The problem has returned. I have split the code into a number of Standard modules all less then 64K and the Useform code module is now 76K, using just the simple techniques (That is, not using classes). But I get the same problem. I have also tried this latest version on Office 2010 Excel...

Thanks for that. I will try that.

Doug, Thanks for the suggestion. Although I am writing a very large Excel VBA application, it is my first one and I am relatively new to the subject. So, I have a question. If I do as you say and create a three liner as the actual Userform code. Will the Userform variables be available in the...

The problem has gone away. It turns out that the problem was caused by hitting a limit of either the allowed number of lines of code allowed for a Userform or the size of the Userform code module itself was greater than a certain limit. I don’t know for certain. I suspected that something was...

Hi, I wonder if you could help me. I am writing an Excel VBA application using a single Userform and a single Module. I was adding some new code to the Userform when I started getting the following error message: "Microsoft Office Excel has stopped working. A problem caused the program to...