Developer tab Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/developer-tab/ Bestselling Excel and Power BI Courses Thu, 09 Mar 2023 11:38:36 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Developer tab Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/developer-tab/ 32 32 How to Use Checkboxes in Excel https://www.xelplus.com/how-to-use-checkboxes-in-excel/ Thu, 15 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9954 Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas or conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.

The post How to Use Checkboxes in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use Radio Buttons in Excel to Create Interactive Dashboards https://www.xelplus.com/excel-dashboards-with-radio-buttons/ Thu, 17 Jun 2021 08:00:00 +0000 https://www.xelplus.com/?p=9999 Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It's really easy once you learn this one trick!

The post How to Use Radio Buttons in Excel to Create Interactive Dashboards 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.

]]> 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.

]]> Excel ActiveX Combo Box with VBA https://www.xelplus.com/excel-activex-combo-box-with-vba/ Thu, 20 Sep 2018 12:42:00 +0000 https://www.xelplus.com/?p=9896 Learn how to create an ActiveX combo-box that allows for easy navigation for larger workbooks. While we're creating this, you also learn about Excel's Event procedures.

The post Excel ActiveX Combo Box with VBA appeared first on Xelplus - Leila Gharani.

]]>