Chapter Summary

In this chapter, you learned the difference between the subroutine procedures that perform actions and function procedures that return values. You saw examples of function procedures called from another Visual Basic procedure. You learned how to pass arguments to functions, and determine the data type of a function's result. You increased your repertoire of VBA keywords with the ByVal, ByRef, and Optional keywords. Finally, you learned how, with the help of parameters, subprocedures can pass values back to the calling procedures.

After working through this chapter, you should be able to create some custom functions of your own that are suited to your specific needs. You should also be able to interact easily with your users by employing the MsgBox and InputBox functions.

Chapter 5

0 0

Post a comment