VBA functions use in ArcGIS Field Calculator

Question

Would this be ok to use them for the field calculator in ArcGIS 9.3 ? See here MS Excel VBA Functions

Or should I fix them in MS Excel and save as a file and then use the join with the shapefile or file geodatabase. Will this work ? Will ArcGIS read it in table ?

Please advice as I am looking for information on how to use field calculator.

Thanks

Answer 1

Here is a technical document describing some of the basic VBA calculator functions, with links to some short walk-throughs. And here is some narrative (with examples) on using the Field Calculator and VBA.

Remember that using VBA in the field calculator is only valid for 9.3.1 and not 10 (which uses python and VBScript).

Answer 2

You can open field calculator and use a function like...
ltrim [my_field]
Then in field calculator you will see a save button.
This will save a file that can be reloaded in caclulator.
You can view this file in notepad (or other text editor).
As blah238 said the knowledgebase article will help show what can and can't be used.

NOTE: You will only be able to use field calculator on the left side of your join (unless you create a dbf file with an oid and join that).
Esri join
Calculations
Examples