Procedure in Excel VBA | Part 3

preview_player
Показать описание
Procedure in Excel VBA:
Requirement: Microsoft Excel 2019

In Excel VBA, a procedure is a block of code that performs a specific task.
Procedures help organize code into manageable sections and can be called from other parts of your program or triggered by events (like opening a workbook or clicking a button).
There are two main types of procedures:
1. Sub Procedures:
These are defined with the Sub keyword and do not return a value.
Insert a shape and write submit and assign a macro it.

2. Function Procedures:
A Function procedure, on the other hand, performs an action and returns a value. It is defined using the Function keyword.
Overview:
Sub procedures are used for tasks that do not need to return a value.
Function procedures perform calculations or operations and return a value.
Both types of procedures can help organize and reuse code in your Excel VBA projects.
Рекомендации по теме