VBA Archives - Xelplus - Leila Gharani

Excel VSTACK Function – The One Excel Formula to Append Them All

Leila Gharani — Thu, 26 May 2022 23:55:00 +0000

This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

The post Excel VSTACK Function – The One Excel Formula to Append Them All appeared first on Xelplus - Leila Gharani.

What’s the Difference Between Excel VBA and Office Scripts

Leila Gharani — Mon, 24 May 2021 11:19:00 +0000

What's the difference between Excel VBA macros and Office Scripts? Do you need to switch from VBA to Office Scripts? Find out in this detailed article. I show examples of what you can achieve with VBA and the current status of Office Scripts and explain what each is for.

The post What’s the Difference Between Excel VBA and Office Scripts appeared first on Xelplus - Leila Gharani.

Learn Excel Macros in 10 Minutes

Leila Gharani — Fri, 02 Apr 2021 04:48:00 +0000

If you find yourself repeatedly performing the same steps in the same order in Excel, your brain should immediately declare, “I should automate this with an Excel macro!”. You will see that VBA doesn't have to be scary and that you can easily generate VBA code by recording your actions.

The post Learn Excel Macros in 10 Minutes appeared first on 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 Use Excel VBA GetOpenFileName to Browse and Select File

Leila Gharani — Thu, 26 Sep 2019 09:00:00 +0000

You can use Excel VBA GetOpenFileName method to copy data from another Excel file by browsing for and selecting the file from the Open File Dialog Box.

The post How to Use Excel VBA GetOpenFileName to Browse and Select File 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.

How to use the Message Box in Excel VBA

Leila Gharani — Sun, 10 Feb 2019 23:24:00 +0000

Learn the correct Excel VBA syntax to be able to create a message box in Excel. It's easy to create a standard message box or a "yes", "no" message box where the user needs to make a decision before proceeding.

The post How to use the Message Box in Excel VBA appeared first on Xelplus - Leila Gharani.

Reset Dependent Drop-down in Excel

Leila Gharani — Fri, 14 Dec 2018 00:07:00 +0000

Excel data validation dependent drop-down values don't automatically reset once you change the value of the first drop-down. Learn how to quickly reset this with a tiny bit of VBA.

The post Reset Dependent Drop-down in Excel appeared first on Xelplus - Leila Gharani.

Excel VBA: Check If File or Folder Exists (DIR)

Leila Gharani — Thu, 22 Nov 2018 15:18:00 +0000

Discover how the DIR function works in VBA. It returns a string that represents a directory or file that matches a defined pattern. This is helpful when you need to refer to other files or folders in your macro. You can also check if a folder exists, and if it doesn’t, create a new folder in the directory.

The post Excel VBA: Check If File or Folder Exists (DIR) 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.