Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

Category Archives for VBA

VBA To Create a Pivot Table [Macro Code]

Macro Codes To Create A Pivot Table

Before I hand over this guide to you for 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 wrote a macro code to create a pivot table, it was a failure.Since then I have learned more from my bad […]

Check it out now

Add Developer Tab [Windows + Mac]

get developer tab in excel ribbon

Developer tab in excel is one of the most important and highly useful options in excel. But, before you use it you need add it on ribbon.When you install Excel, you need to activate it for first time.So today in this post, you will learn 3 different methods to add developer tab in Excel for windows as well […]

Check it out now

VBA MsgBox Function

vba msgbox function in excel

The first thing which I have learned about in VBA was using a message box.You can also call it msgbox which is its actual syntax. It’s like a simple popup box on your window.If you think about a msgbox, it has two main usages in VBA as a function.Deliver a message to the user.Get a […]

Check it out now

VBA ON-OFF Button In Excel

Today, I’d like to share with your simple steps to create an on-off button in Excel.I have used this button to create a greeting card for Christmas. So, let’s start our hunt for an on-off switch/button.What Will it Do?It can help you to control two macros with one button. You can also use it to […]

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