Hi,

How do you create a function where you leave it to the user of the excel sheet to define which values the in-parameters should take by letting the user state the cell references (which holds these values)?

For ex if I have created a very simple function which is called "mulitply" and which multiplies two values and I want to give the user the possibility to write (in the excelsheet) the formula:
=multiply(A1;B1)
so that this function goes into these cell references and look for values and then multiply the value in A1 with the value in B1, how do achieve this in my VBA custom Function code?