Excel Custom Functions: possibility to provide list of predefined values for parameters

Excel Custom Functions: possibility to provide list of predefined values for parameters
9

Upvotes

Upvote

 Jan 20 2022
1 Comments (1 New)
New

Sometimes custom function might have parameters which accept only a couple of predefined options/values. It would be nice to have a feature which allows the user to see those possible options (for selection, like in a drop-down list or similar) as soon as he starts typing in the custom function into a cell.

Comments
Copper Contributor

So now is there having a solution?