Include suggestions for arguments in VBA Function

[JonSalzman]

Hi All,

When using existing functions within Excel, suggestions pop up when you begin typing within the function for what each argument should be (e.g. when using Sum, it says SUM([number1],[number2],.....). Is there some way to make new functions written in VBA also give these types of suggestions? I'm writing this: Function SumFirst(pname As String, firstxcol As Integer, rng As Range) As Single and would like suggestions to pop up for input when calling the function directly in a sheet.

Thanks

[walruseggman]

I don't think this is possible in VBA w/o using C# or something, though even that seems of limited success.

Take a look at this post where I recommended an alternative. Maybe that will be sufficient for you?

http://www.excelforum.com/excel-programming-vba-macros/1125880-excel-function-tooltip.html

[GeneralDisarray]

I don't know how make the suggestions pop up like a native function, BUT I do have a neat trick to give you the variable names (so you at least don't have to remember them).

Type the function, all the way to the first "(" then press cntrl+shift+A -- that will fill in the variables (which you can then over-write)


So:

Type: =SumFirst( then press cntrl+Shift+A and you will get this: =SumFirst(pname, firstxcol, rng) You can then replace the variable names with what you need :D

[JonSalzman]

These two answers are perfect, that control+shift+A trick is pretty much it. I'm the only person who will really use the function so that does the job perfectly. Thanks for the help!