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.

10000+ Copies Already Downloaded

Category Archives for VBA

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

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

Check it out now