Excel VBA Loops Explained

Loops are very important when coding as it can help repeat the same action without rewriting the same piece of code over and over.

There are a few different loop statements in VBA, we will see some examples of the most used once here.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to open and close a workbook in VBA

Opening a workbook in VBA

To open a workbook we will use the VBA Open workbook method.

The basic VBA code to open an excel file is:

Workbooks.Open (“File_Name”)

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

Error Handling in Excel VBA

Error handling in VBA (and any programming language)  is anticipating an error and taking the right steps to make sure this error is dealt with before moving on to the next bit of code, to avoid the macro stopping abruptly.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

Excel VBA IF Statement

Excel IF statement is a very powerful tool in VBA (and any programming language) and is used to check if a condition is TRUE or FALSE and perform a certain action depending on the result.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

Creating a Pie Chart in Excel

Pie charts are a type of graph where a circle is divided into portions (slice) that display the contribution of each section to a total value (pie). This type of chart is commonly used to visually show proportions of a whole. For example, how much each quarterly sale contribute to annual sales. In this article, we are going to cover how to make a pie chart in excel, pie chart examples, its elements and layout.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

Learn how to use the Excel functions SUMIF and SUMIFS

Excel Functions SUMIF and SUMIFS sum up numeric values that meet specified criteria. These criteria can be based on dates, numbers, or text. Criteria based on dates and text must be enclosed with double quotes (i.e. “01/01/2019”). On the other hand, a number will require double quote only if it has operators (i.e “>100”). Otherwise, the double quote is not required. Both functions support logical operators such as “Greater Than” (>), “Less Than” (<), “Not Equal to” (<>), “Equal” (=)  and wildcards (*,?) for partial matching. Although both functions support calculations based on criteria, Excel SUMIF calculate values based on a single criterion while SUMIFS is based on multiples criteria.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

Learn how to use the Excel functions COUNTIFS and COUNTIF

Excel Functions COUNTIFS and COUNTIF count cells with values that meet specified criteria. These criteria can be based on dates, numbers, or text. Criteria based on dates and text must be enclosed with double quotes (i.e. “01/01/2019”). On the other hand, a number will require double quote only if it has operators (i.e “>100”). Otherwise double quote is not required. Both functions support logical operators such as “Greater Than” (>), “Less Than” (<), “Not Equal to” (<>) , “Equal” (=)  and wildcards (*,?) for partial matching. Although both functions support calculations based on criteria, Excel COUNTIF count cells with values based on a single criterion while COUNTIFS analyze based on multiples criteria.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

HIDE or UNHIDE ROWS and COLUMNS in Excel

Hiding or Unhiding Rows and Columns are one of the most popular commands in Microsoft Excel. These commands come in handy and easy to execute with the help of few mouse clicks and shortcut keys. In this article, we are going to cover how to hide/unhide columns and rows in excel manually and via shortcut keys.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to Use IF in VBA

Microsoft Excel IF statement is used in VBA Coding. It executes a set of defined code if the specified condition evaluates TRUE. IF statements are one of the foundational concepts in VBA programming and is one of the most frequently used statements. In this article we are going to discuss how to use IF statement in VBA programming.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to use Case Statements in VBA

The VBA Select Case statement is another way to analyze a condition in Excel and can be used to replace the traditional If-Then-Else statement in excel.

The Select Case Statement in VBA is the equivalent to the Switch Case statement in other programming languages.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit