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

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

Upvotes

Upvote

 Jan 20 2022
0 Comments 
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.