Yah I saw that post earlier but does not give or direct to where the macro would be. I have the moon phase working, that is easy, but am needing the moonrise and moonset time based on your lat/lon. kd4dna posted on that thread that he had made the script, but did not post it.
You may not find one specifically written in VBA so I searched for algorithms for this. If you look for the algorithm you may find a description of how to code it or possibly find it in another language that you can convert. Using this approach I found this site (http://aa.usno.navy.mil/faq/docs/rs_algor.php) which refers to another (http://www.skyandtelescope.com/resources/software/3304911.html) and says that there is a BASIC program for doing this called MOONUP.BAS. Unfortunately it's not listed there any more. However these sites may give you other leads.