With custom functions in Excel, how do I make a text box appear to remind the user what arguments are required

Question

For example if you wrote a function for finding the area of a rectangle RectArea( Height, Width) how do you program a prompt to appear reminding the user what arguments are required (For example on vlookup a text box appears underneath with lookup_valuek, table_array,.... etc.

Answer 1

I'm not exactly sure how to do that, but if you go to:

Insert > Function

Then pick the User Defined category it will list the custom functions and the arguments for the functions.

Answer 2

Normally this is usually handled by excels function explainer anyway, when they start to type the function into the formula bar it should come up with a label under the text to tell them how to correctly format what they are typing. To see this in action you could for example type =if( into the formula bar and it will bring up how to format the rest of the function

Answer 3

just make a note