T
Tdp
Is there a vb code checker programme that anyone can recommend?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
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
T
Tdp
Thanks Mike
--
Tdp
--
Tdp
Mike H said: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
J
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.
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.