VBA Function inputs

**BFlick11** · 10-04-2010, 03:57 PM

When you type a built in excel function like "=sum(", excel then prompts a statement below that reads SUM(number1,[number2],..). My question is how to make a VBA function make a similar prompt asking for the inputs that the function is requring?

Thanks

**JBeaucaire** · 10-04-2010, 03:59 PM

The only way I've ever seen is a very complicated "hack" of some other function already in Excel you know you'll never use. Not sure I could recommend that.

**romperstomper** · 10-04-2010, 04:14 PM

You can't, AFAIK. You can add help for the arguments to the function wizard, but you can't produce the tooltip (though I think in 2010 you can if you create an XLL).

**BFlick11** · 10-04-2010, 04:23 PM

what about for a sub?

**romperstomper** · 10-04-2010, 04:25 PM

Where would you have a tooltip for a sub??

**JBeaucaire** · 10-04-2010, 05:34 PM

Actually you have a "little" help on subs and UDFs.

After you've created your sub, press Alt-F8 from the main worksheet view and click on the macro in the popup list...then click on OPTIONS. Now you can not only select a shortcut key to activate the sub, but you can type out a full description.

The Description will appear in the macro window when manually select macro (look at the bottom of the window as you click on it) and for UDFs the Desc would appear if you were using the Insert Function wizard.