There are a couple of ways to call a procedure from within another procedure, although using the Call keyword and enclosing your arguments in parentheses is the preferred method.
You can create your new subroutines by using the (Insert > Procedure) dialog box.
If you type it in directly the appropriate ending (either End Sub or End Function) will be inserted automatically.

microsoft excel docs

Name - The name of the procedure you want to create.
Type - The type of procedure, either subroutine, function or property.
Scope - The scope of the procedure, either public or private. Public can be accessed from other modules. Private can only be accessed from this module.
All Local variables as Statics -

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext