VBA Sub Statement Archives

VBA Sub Statement

How to Return Values from a Sub in Excel VBA (4 Methods)

Nighat Hossain February 7, 2026

In Excel VBA, a Sub procedure is one of the most common ways to automate tasks. A Sub can perform actions. For instance, calculating results, updating cells, or formatting results. However, it does ...

Excel VBA

Private Sub vs Sub in Excel VBA: All You Need to Know

Mohammed Shafin Arshad February 7, 2026

When writing procedures in Excel VBA, you’ll often come across both Sub and Private Sub. While they may look similar, they serve different purposes, mainly when it comes to scope and accessibility. ...