Looping Archives - Xelplus - Leila Gharani

How to Create a Custom Progress Bar in Excel with VBA

Leila Gharani — Wed, 15 Apr 2020 09:00:00 +0000

A progress bar is a great addition for Excel macros that take long to run. It gives your project a more professional touch. It's also quite easy to add. You can create your progress bar once and reuse it in your Excel VBA projects.

The post How to Create a Custom Progress Bar in Excel with VBA appeared first on Xelplus - Leila Gharani.

How to Sum Cells by Color in Excel

Leila Gharani — Thu, 18 Jul 2019 09:00:00 +0000

Use this Excel formula to sum cell values based on cell color. The formula is an Excel VBA function. Copy and paste the code in your files so you can sum values based on background cell color.

The post How to Sum Cells by Color in Excel appeared first on Xelplus - Leila Gharani.

Excel VBA: Loop Through Cells Inside the Used Range (For Each Collection Loop)

Leila Gharani — Sat, 05 Jan 2019 16:54:00 +0000

Learn how to use the FOR EACH Collection Loop in Excel VBA. This way you can quickly loop inside a specific range, manipute the data or check for a condition. In this example we count the number of cells that contain formulas in the UsedRange.

The post Excel VBA: Loop Through Cells Inside the Used Range (For Each Collection Loop) appeared first on Xelplus - Leila Gharani.

Excel VBA IF THEN Statement (and a useful tip)

Leila Gharani — Thu, 23 Aug 2018 16:15:00 +0000

Learn one of the most useful statements in VBA (or any programming language, really): If Then. Once you master If, Then, Else, Elseif and And, you will be able to write Excel macros that are dependent on multiple conditions.

The post Excel VBA IF THEN Statement (and a useful tip) appeared first on Xelplus - Leila Gharani.