Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Checking and IF ? | Excel Worksheet Functions | |||
Day Checking | Excel Discussion (Misc queries) | |||
Checking Hyperlink | Excel Discussion (Misc queries) | |||
Add checking | Excel Worksheet Functions |