BY TOPIC
EXCEL / VBA BLOGS
VBA MACROS BLOGS
- Recording macros (1)
- Working with ranges (4)
- Input/message boxes (3)
- Variables, arrays (3)
- Enumerations (2)
- Loops and conditions (2)
- Errors and debugging (2)
- Functions / arguments (3)
- Events (2)
- User forms (6)
- Classes (4)
- References (9)
- Files and folders (4)
- General (11)
- Working with charts (4)
- Flappy Owl (14)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Functions / arguments in VBA macros
Showing blogs 1-3 (out of 3)
A short-cut key to bring up the arguments of user-defined functions
Posted by Andy Brown on 17 June 2019
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.
Writing functions for Excel using VBA
Posted by Andy Brown on 24 February 2012
On-line training in writing functions using VBA, for use either within other VBA programs or within Excel itself.
Passing arguments to subroutines in VBA
Posted by Andy Brown on 09 February 2012
To become an efficient programmer, you need to stop writing one long subroutine and start writing lots of small ones instead - and to do this, you're going to need to know everything there is to know about passing arguments.