Checking vb codes?
 

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?
--
Tdp

Checking vb codes?
 

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" wrote in message
...
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?
--
Tdp

Checking vb codes?
 

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

Thanj you
--
Tdp


"Harald Staff" wrote:

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" wrote in message
...
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?
--
Tdp