Welcome to Mike's Excel VBA Pages where you can find various applications of VBA for Excel in the fields of statistics, actuarial science and finance. The pages contained on this site may be of interest to people who are learning VBA or its applications in math and finance. The code I provided would give you an informative look into the use of VBA for Excel in probability modeling, simulation and financial modeling.

Visual Basic is one of the easiest languages I have learned. Visual Basic for Application is based on VB that is customized for windows applications. VBA for Excel allows users to develop custom applications of Microsoft Excel. Most powerful uses of its applications include automating repetitive tasks, data analysis and manipulation, modeling and simulation.

I've been writingVB code since May 2002. The programs I put on this site are VBA version of some of the programs I coded. Some of the functions of these programs were eliminated, or their capacities were reduced because of the limits of VBA.

Thank you for visiting this site. I hope you find them useful and informative. If you have any questions or comments, please write me E-mail at shliao73@hotmail.com.