Module 0170: Writing and using subroutines in VBA

Tak Auyeung, Ph.D.

May 4, 2009
1 About this module
2 Functions and subroutines
 2.1 General concepts
 2.2 Parameters
3 Subroutine in VBA
 3.1 An example
 3.2 Subroutine versus Function
 3.3 ByVal and ByRef
4 Integrating your own functions in Access
 4.1 An example
 4.2 What is a VBA “Module”?
5 Summary