Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
547 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
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
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:
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?
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.