Error running VBA script, expected end of statement

Error Message

When running an advanced expression in the Field Calculator, the following error message is returned:

"Error running VBA script, expected end of statement."

Cause

Visual Basic for Applications (VBA) has not been installed or is not at the correct version.

Solution or Workaround

1. Verify that the VBA has been installed by selecting Tools > Macros. If the Visual Basic Editor is grayed out, the editor has not been installed.
2. At version 8.x, VBA can be installed by running the ArcMap_vba.msi under the \Support\Vba6 folder found on the install CD.
3. At 9.3 and 9.3.1, VBA can be installed by running the VBAOF11.msi and VBAOF11I.msi under the VBA and 1033 folders found on the install CD.
   
   • At 9.3, it is recommended that a repair is run on the ArcGIS Desktop install.
   
   A) To run a repair, insert the ArcGIS installation disk.
   
   B) Click Exit and navigate to Start > Settings > Control Panel > Add or Remove Programs. Select ArcGIS Desktop and click the Change button. When prompted, select the Repair option.