Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB code checkers?????????
Is there a vb code checker programme that anyone can recommend?
-- Tdp |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB code checkers?????????
Hi,
The tools provided in VB editor are pretty comprehensive and will ensure you get code that will compile. After that no code checker could decide if the code is doing what you want because code will do what you tell it do do which often isn't what you want. Have a look here for some useful tips http://www.cpearson.com/excel/Debug.htm Mike "Tdp" wrote: Is there a vb code checker programme that anyone can recommend? -- Tdp |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB code checkers?????????
Thanks Mike
-- Tdp "Mike H" wrote: Hi, The tools provided in VB editor are pretty comprehensive and will ensure you get code that will compile. After that no code checker could decide if the code is doing what you want because code will do what you tell it do do which often isn't what you want. Have a look here for some useful tips http://www.cpearson.com/excel/Debug.htm Mike "Tdp" wrote: Is there a vb code checker programme that anyone can recommend? -- Tdp |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB code checkers?????????
Mike H has pretty much said it all. One of the best things you can do for
yourself in writing VBA code in Excel (or anyother VB enabled application) is to use Option Explicit which can be set up to automatically be put into effect using Tools | Options in the VB Editor and checking the box next to "Require Variable Declaration" on the [General] tab. This can really help reduce logic errors caused by typographic errors in typing the names of variables/constants. After that, you're pretty much on your own as far as getting the code logic correct, while the VB Editor will do a pretty good job of dealing with finding your syntax errors. "Tdp" wrote: Thanks Mike -- Tdp "Mike H" wrote: Hi, The tools provided in VB editor are pretty comprehensive and will ensure you get code that will compile. After that no code checker could decide if the code is doing what you want because code will do what you tell it do do which often isn't what you want. Have a look here for some useful tips http://www.cpearson.com/excel/Debug.htm Mike "Tdp" wrote: Is there a vb code checker programme that anyone can recommend? -- Tdp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Code expantion , with code! | Excel Discussion (Misc queries) | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |