create a function

[laureenl]

how do i create a function that allows a user to select a range of cells
and after which, multiplying the range of cells selected?

[Mallycat]

Function MultiplyCells(myRange As Range)
x = 1
For Each Cell In myRange
x = Cell.Value * x
Next Cell
MultiplyCells = x
End Function

[laureenl]

Hey: ) thank you so much : )

Is it possible to allow the user to have an option in choosing the output he or she wants in the function?

For example:

Choice A: MultiplyCells = (x-1) * 10000
Choice B: MultiplyCells = (x-1) * 100
Choice C: MultiplyCells = x-1