vba Argument Dropdowns

[UNIVAC]

Windows XP: Office 2003

If you use MsgBox, when you enter the buttons argument a drop-down list will appear from which you can select the buttons you want. Many other functions offer this drop-down capability when entering arguments.

How can I embed the drop-down feature in my own user-defined functions? This would be useful when using a function both in a SS and in vba code.

To know how to embed these drop-downs in my function arguments would take my programs to a much higher level.

Thanks

[Leith Ross]

Hello UNIVAC,

VBA doesn't support IntelliSense for user defined functions.

Sincerely,
Leith Ross