copying website name in excel

[Dalia]

Hi,

I want to search college institutes of a specific region in Google and want to take the URL of the official website of the college and paste it in excel as hyperlink. how can I do that by VBA macro

 

[Eloise T]

I'm not sure how, or if it can be done via VBA (as soon as I say it can't, someone will prove me wrong), but do you know how to do it manually? If not, see below...

Select the cell you want to use for the link, right click on the cell and select Hyperlink. Put the college web-site in the appropriate blank.




Next select Insert tab then Shapes. Select a shape which will make the "button" you push to go straight to the college web-site.



Finally, right click on the "button" and select Edit Text and label the button with the name of the college.
Hopefully that helps.