Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

Category Archives for VBA

Count Unique Values in Excel

    Let’s say you have a list of values where each value is entered more than once. And now, you want to count unique values from that list so that you can get the actual numbers of values which are there in the list. For this, you need to use a method which will count a […]

    Check it out now

    How To Highlight Duplicate Values Using VBA

      highlight duplicate values using vba

      While working with huge data, Duplicate Values are always a concern. And, I am sure most of the time you remove them with remove duplicate option. But, removing duplicate values or just counting duplicate values never sort out the problem. The important thing is to review all the duplicate values before deletion. So, today I will […]

      Check it out now

      Useful Macro Codes For VBA Beginners

        useful macro codes

        Do you know with the help of these useful macros, you can break all the limitations of excel which you think excel has? You can use these macro codes even if you haven’t used VBA before that. All you have to do just paste these useful macros codes in your VBA editor. These codes will […]

        Check it out now

        How To Use VBA IF Statement To Write Conditions [Ultimate Guide]

          a practical guide to learn about VBA IF Statement in excel

          IF statement is one the most important parts of VBA coding. And, I am damn sure that after reading this guide, you will be able to write any type of conditional code by using this IF statement in VBA. Let me tell you something. Yesterday, I received a mail from one of my reader which […]

          Check it out now

          How to Insert Checkbox In Excel [Last Guide You Need]

            Do you know how to insert checkbox in excel? I bet you know. But do you know how to use it up to its best? If no, I’ll tell you. In this post, I will show you how to insert checkbox in excel. But, along with that, I will show you some tips to customize […]

            Check it out now

            Use VBA To Create Pivot Table In Excel

              Macro Codes To Create A Pivot Table

              Before I hand over this guide to you about using VBA to create a pivot table, let me confess something. I have learned using VBA just three years back. And, the first time when I had used a macro to create a pivot table, it was a failure. Since then I have learned more from my […]

              Check it out now

              How to Add Developer Tab In Excel Ribbon for Window & Mac

                Developer tab in excel is one of the most important & highly useful options in excel. But, before using this gem you have to activate it in your Excel. In this post, I will show you how to Add Developer Tab In Excel in windows as well as in excel 2011 for mac. How To Show It In Your Excel […]

                Check it out now

                A Ultimate Guide To Learn About VBA MsgBox Function

                  vba msgbox function in excel

                  Here is your ultimate guide to master VBA Msgbox Function. You can use VBA Msgbox Function in excel to get a simple popup box on your excel’s window. If you really think about VBA MsgBox Function, it has two main roles in your VBA. Deliver a message to the user. Get a simple response from the […]

                  Check it out now

                  How To Create VBA ON-OFF Button In Excel

                    Today, we will learn that how to create an on-off button in excel. Okay. So, Let’s start our hunt for an on-off switch. How will an on-off switch be usable? It can help you to control two macros with one button. You can also use it to start or stop a macro. Points to consider It should […]

                    Check it out now

                    Internet Radio in Excel – Play Music Directly From Your Spreadsheet

                      Peter is talking about his new internet radio in excel. Steps to Create an Internet Radio in Excel Go to Developer Tab -> Controls -> Insert -> Active X Control -> More Control. Select Window Media Player from the list. Now, double click on the window media player. And, By clicking on it, you will […]

                      Check it out now