Too long code

[episode80]

Hi,

I have a long code behind a command button. Now, when I try to run it I'll get an error tag which says that code is too long. How can i solve this problem? It isvery essential that all that code is behind this command button.

Thanks!

-episode80

 

[HarleyQuinn]

Could you not put it in a module and call the module from within the command button's event??

Harleyquinn

---------------------------------
For tsunami relief donations

 

[strongm]

You are saying that you have a single, monolithic block of code that contains more than 64K of code?

 

[chiph]

Sounds like you need to break your code up into separate functions/subroutines.

Like strongm says, there's a 64k limit on the amount of code you can have in a method. I don't know if it's 64k of characters, or 64k of interpreted code, but in either case, if you're anywhere near the limit, you need to refactor your code now!

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first