AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. Eric suspects there will be similar requests in the future and wants the function he creates to be available for various database procedures. You suggest Eric define the function in a ____.
A) control
B) subroutine
C) case
D) module

Question

Quizplus · Accepted Answer

A module is a logical container where VBA code is stored. By defining the function in a module, it can be used by other procedures within the same module or in other modules. This will make the code more modular and reusable, which is important for future requests like Eric anticipates. Control, subroutine, and case do not provide the necessary functionality for defining a VBA function.

AC Adv Case 13-1 Eric Has Been Asked to Write