VBA & Scripts Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/vba-scripts/ Bestselling Excel and Power BI Courses Tue, 05 Dec 2023 13:28:33 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png VBA & Scripts Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/vba-scripts/ 32 32 How to Use Office Scripts with Power Automate https://www.xelplus.com/office-scripts-with-power-automate/ Thu, 12 Aug 2021 08:00:00 +0000 https://www.xelplus.com/?p=9855 Learn to combine Office Scripts with Power Automate so you can run your macros without opening your files. You'll learn how to create a script, how to loop through each sheet in the script and how to setup Power Automate to apply the script to every file in a folder.

The post How to Use Office Scripts with Power Automate appeared first on Xelplus - Leila Gharani.

]]> Introduction to Office Scripts https://www.xelplus.com/office-scripts-macros-on-the-web/ Fri, 28 May 2021 11:09:00 +0000 https://www.xelplus.com/?p=10010 This example gets you started with Office Scripts in Excel. You'll learn how to record a macro and how to modify the script to get a dynamic range. You'll also learn where to find the Office Script and how to save it with your workbook.

The post Introduction to Office Scripts appeared first on Xelplus - Leila Gharani.

]]> What’s the Difference Between Excel VBA and Office Scripts https://www.xelplus.com/excel-vba-vs-office-scripts/ Mon, 24 May 2021 11:19:00 +0000 https://www.xelplus.com/?p=10101 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 https://www.xelplus.com/learn-excel-macros/ Fri, 02 Apr 2021 04:48:00 +0000 https://www.xelplus.com/?p=10171 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 https://www.xelplus.com/excel-vba-progress-bar/ Wed, 15 Apr 2020 09:00:00 +0000 https://www.xelplus.com/?p=11381 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 Find Formulas that use External Links in Excel https://www.xelplus.com/excel-external-links-trick-dynamic-arrays/ Thu, 24 Oct 2019 09:00:00 +0000 https://www.xelplus.com/?p=12045 Get a list of all your external links in your Excel file with a trick that combines the past with the future. This way you can make sure all your links are pointing to the right files.

The post How to Find Formulas that use External Links in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel VBA GetOpenFileName to Browse and Select File https://www.xelplus.com/excel-vba-getopenfilename/ Thu, 26 Sep 2019 09:00:00 +0000 https://www.xelplus.com/?p=12084 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 https://www.xelplus.com/excel-sum-cells-by-color-vba/ Thu, 18 Jul 2019 09:00:00 +0000 https://www.xelplus.com/?p=12283 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 List Box to Display & Print Multiple Sheets as ONE Print Job with VBA https://www.xelplus.com/list-box-to-print-multiple-sheets-excel-vba/ Sun, 05 May 2019 10:48:00 +0000 https://www.xelplus.com/?p=12473 In this Excel VBA & macros tutorial, you will learn how to create a ListBox that contains the names of the worksheets. You can select multiple names and then print the sheets as one print job instead of separate ones.

The post Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA appeared first on Xelplus - Leila Gharani.

]]> 3 Methods to Unhide All Sheets in Excel (& how to hide) https://www.xelplus.com/3-methods-to-unhide-all-sheets-in-excel/ Thu, 07 Mar 2019 12:17:00 +0000 https://www.xelplus.com/?p=12816 Learn how to quickly hide and unhide all worksheets in at once. Hiding sheets in Excel is easy, but unhiding all sheets is not as simple. I show you 3 methods to unhide Excel tabs. Pick the one you like most.

The post 3 Methods to Unhide All Sheets in Excel (& how to hide) appeared first on Xelplus - Leila Gharani.

]]>