Excel VBA Macro URL to Hyperlinks text How to and Demonstration. Hyperlinks.Add method

This Excel video tutorial shows how to create a Macro in Visual Basic (VBA) and can be very useful for Microsoft Excel VBA beginners. Visual Basic for Applications is the programming language of Excel and other Office programs. With Excel VBA you can automate tasks in Excel by writing so called macros.

So, here I demonstrate Excel macros that help me in real cases in my Data Analyst role at my job. This Excel Macro (URL Hyperlink to Text) convert URL Hyperlink (like http://www.excelmacros.com) to normal and readable text as "Link to source" or "Press Here".

For this purpose Hyperlinks.Add method with parameters Anchor, Address, Screen Tip and TextToDisplay were used.

In the result you can convert all selected Excel cell that contains URL addresses to a normal text just by run this Macro!

If you wish to get more existing Data Analyst video like this, just follow me! -    / vytautasbielinskas  
LinkedIn profile:   / bielinskas  

Vytautas