procedure can't exceed 64K

[The_Vulcan]

Hi

I have a long chunk of code on a form that I am using to print, but it has gotten just a little to long.

Private Sub CommandButton3_Click()
..............
End Sub

There are lots of repeated bits.

The quick fix I am after is someone telling me I can put chucks into a module and pass the info the form gathers to the module.

Or that I can create a "Class" ? That I can put the large bits of repeated code into and call on that. Rather than have it repeated.


Any quick fix will do =)

[marcospaterson]

have you tried to name different variables and working with do while and loops?