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

• blah238: Some of those functions are built-in to VBA, some are specific to Excel. For examples of VBA functions available in the field calculator see: support.esri.com/en/knowledgebase/techarticles/detail/31807
• PROBERT: Can anyone tell me how to use it to force the decimals remove and replace with the comma. Here I have a column with acres like this 506320.0750 and I want this (506,320) to display permanmently ?
• blah238: Please ask a separate question for this.
• PROBERT: I posted in a separate question.

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