Probably the best way to start understanding the syntax  is to record several
simple macros and then inspect the code. Also, while inspecting it, place
your cursor in various commands within the code and press F1 while in the VB
editor. Assuming you did a custom install and added the VBA help file,
you'll go to the VBA help for that command where you can find details about
the syntax and options.

Another way would be to obtain a VBA code language resource book, although I
don't know for sure which ones are now being published. But you can find the
same info free online through MSDN (Microsoft Developer's Network), here:
msdn.microsoft.com/.../htm
l/Welcome_HV01134775.asp