If you are relying on the field calculator in ModelBuilder you should not use VBA, since there is no support for VBA in the field calculator once you upgrade to ArcGIS 10 (or beyond) and VB Script at ArcGIS 10 cannot do geometry calculations. You should use Python (ModelBuilder supports Python in the Field Calculator, at least by 9.3). That way you can not only use the code in ModelBuilder, but also in a python script (which can then be run in task scheduler) and it should port to future versions of ArcGIS.
The two expressions below should get you the Centroid X and Y coordinates in Python with the Field Calculator.
float(!SHAPE.CENTROID!.split()[0])
float(!SHAPE.CENTROID!.split()[1])