Using the VBA editor, insert a new module and create a custom function to calculate mileage. The function name should be mileage and the variables should be miles and rate. The function should multiply the miles by the rate. Press ENTER, and then close the VBA editor.

Answer and Explanation:

Currently, in order to construct a method to measure the within VBA, so we have to follow these steps.

Firstly, Construct the cost as well as rate method measurement as the variables.

That is :      

The following function will returns the mileage as the result that is .