Protect your training budget AND save money with our new pre-payment vouchers.
A short-cut key to bring up the arguments of user-defined functions
When you discover a new short-cut key, should you share it? This blog shows a way to bring up Intellisense for the arguments to user-defined functions in Excel VBA.

Posted by Andy Brown on 17 June 2019

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Showing the Arguments for a VBA user-defined function

It's not often we discover a new Excel short-cut key (thanks to Wayne Edmondson for this), so we thought we'd share it!

Suppose that you've written the following excellent user-defined function in VBA:

Function Multiply(FirstNumber As Integer, _

SecondNumber As Integer) As Integer

'return the product of the two numbers

Multiply = FirstNumber * SecondNumber

End Function

This function takes two numbers, and calculates their product.  You could argue that the * key does the same thing more easily ...

You then try referencing your function in your workbook, but no argument list appears:

Function without arguments

You know you've got the function name correct, but can't remember the arguments you need to pass to it.

Step forward Ctrl + Shift + A ! When typing in formula as above you can press this short-cut key combo to bring up the arguments:

The list of arguments

Now you can see what the arguments are!

Not earth-shattering, but it might make someone's life a little bit easier perhaps?

This blog has 0 threads Add post