564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
|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.|
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
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:
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:
Now you can see what the arguments are!
Not earth-shattering, but it might make someone's life a little bit easier perhaps?
25 Aytoun Street