UDF with predefined arguments shown in Excel formu

2020-08-01 08:20发布

I am curious if anyone knows of a way to push predefined parameters to the function box in Excel when using a UDF? This explains how to accomplish what I want, but only within the VBA editor: VBA Function argument list select

My UDF has two arguments:

  1. a single cell range
  2. required parameter, either "up" or "down"

I was able to get tooltips (https://github.com/Excel-DNA/IntelliSense) and add UDF/argument descriptors to the function box (Application.MacroOptions), but in an ideal world, I could push the options for the second argument to the GUI also... much like the "true/false" dropdown appears for the fourth argument of VLOOKUP:

enter image description here

(ignore the tooltip overlay in the picture, I am referring to the TRUE/FALSE enumeration below it)

Anyone, know if this can/how this might be accomplished?

标签: vba excel
0条回答
登录 后发表回答