VB code checkers?????????

[Tdp]

Is there a vb code checker programme that anyone can recommend?

 

[Mike H]

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]

Thanks Mike
--
Tdp

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

 

[JLatham]

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.