How to get the URL using vba in excel

I want to import an URL to my excel sheet.

Please help me on how to do it, I am new to Excel