[GIS] VBA functions use in ArcGIS Field Calculator

arcgis-9.3arcgis-desktopexcelfield-calculator

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

Best Answer

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).