Checking vb codes?

[Tdp]

I ave a excell programme which has about 200 textboxes with codes to go along
with it. Evety now and then it crashes with a note saying that the programme
will have to shut down........and so on.
Is there a way to check the codes to see if there are any errors?

 

[Harald Staff]

Hi

Put the line

Option Explicit

on very top of all your code modules. Then go menu Debug - Compile VBA
project.
Also, do some reading on the difference between design time errors and
runtime errors. Even perfect code syntax can kill your computer.

HTH. Best wishes Harald

 

[Tdp]

Thank you Harald,
I shall do the ammendments.
I'v got some homework to do then!!!!

Thanj you