When you define a custom function in excel VBA, how can I display the function variable names when a user types it out in an Excel cell?
For example, if you type "=Sum( " in an Excel cell, you will see a little pop up saying to input a number as per the attached picture: enter image description here
How can you do this with your own functions? For example if I define:
Function MyFunction (Dim Age as Double, Dim No_Pets as Double) as Double
I don't see the name of arguments I am passing to the function when I write it out in Excel.
