contestada

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.

Respuesta :

Limosa

Answer and Explanation:

Currently, in order to construct a method to measure the [tex]miles\times rate[/tex] within VBA, so we have to follow these steps.

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

That is :       [tex]Function\;mileage(miles,\;rate)[/tex]

                   [tex]mileage = miles \times rate[/tex]

                   [tex]END\;Function[/tex]

The following function will returns the mileage as the result that is [tex]miles\times rate[/tex].

Otras preguntas