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

How to Use 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 […]

➲ Continue Reading

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 […]

➲ Continue Reading

How to Create a Internet Radio in Excel

Steps to Create an Internet Radio in ExcelGo 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 get the VB editor.Change the name of window media player to “InternetRadioInExcel”.Open your […]

➲ Continue Reading

How To Create a Table of Content In Excel By Using VBA

To Create a table of content in excel with macro we have to use a Hyperlink.Add Function In VBA which is similar to the Excel’s Hyperlink Function. Use Hyperlinks.Add to insert a hyperlink in excel with VBA It is the part of Hyperlink collection method. Let’s have a look at Arguments of  Add.Hyperlinks : hyperlinks.Add(Anchor, Address, […]

➲ Continue Reading