Excel Range as Hyperlink on a Userform in Excel using VBA

[sanits591]

Hi,

I have an excel sheet, having two columns, Column(1) for the Name allocated to Hyperlink and in other column (2) is the url.

What i would request for the VBA code, which shall copy the Name of the Url on the Userform, with hyperlinks of the range displayed on the userform.

I tried surfing, but nothing sort of this, which shall assist me in finishing this task.

An excel sheet is attached. http://www.box.net/files#/files/0/f/92361839/1/f_805050244


Thanks!

 

[tusharm]

I imagine there will be people who will download your file and invest the time understanding from it what you want. Then, there are those, like me, who would prefer you explain what you want.

What is the format of the URL? And, what does "hyperlinks of the range" mean?

Hi,

I have an excel sheet, having two columns, Column(1) for the Name allocated to Hyperlink and in other column (2) is the url.

What i would request for the VBA code, which shall copy the Name of the Url on the Userform, with hyperlinks of the range displayed on the userform.

I tried surfing, but nothing sort of this, which shall assist me in finishing this task.

An excel sheet is attached. http://www.box.net/files#/files/0/f/92361839/1/f_805050244


Thanks!

 

[sanits591]

Thanks for the Quick response.

This is taken from the Economic Times feeds, for e.g.

Col A
cells(2,1)= Indian Visiting UK can now travel to Ireland without VISA

Col B
cells(2,2)=http://economictimes.feedsportal.com/c/33041/f/537910/s/165ce904/l/0Leconomictimes0Bindiatimes0N0Cnews0Cnri0Cvisa0Eand0Eimmigration0Cindians0Evisiting0Euk0Ecan0Enow0Etravel0Eto0Eireland0Ewithout0Evisa0Carticleshow0C90A77690A0Bcms/story01.htm
(The above cell is not a hyperlink, only a text written in a cell)

This way the entire column A & B goes on with the following text.

Hyperlinks of the range stands for Col B.

Additionally i want as soon as the link on the userform is clicked, then webbrowser to be opened in the same userform displaying the content.

Thanks!

 

[tusharm]

I'm not sure I understand what you want.

Do you want someone to develop the complete solution for you? If so, I may be wrong but that is not what I consider the purpose of a forum such as this.

You may want to get started on the process and ask questions as you run into issues.

An alternative to consider is to use the HYPERLINK function within Excel. It takes a hyperlink and a title as its arguments and creates a clickable hyperlink. From what I can tell of your task, using a userform doesn't seem to add anything more to the functionality.

Thanks for the Quick response.

This is taken from the Economic Times feeds, for e.g.

Col A
cells(2,1)= Indian Visiting UK can now travel to Ireland without VISA

Col B
cells(2,2)=http://economictimes.feedsportal.com/c/33041/f/537910/s/165ce904/l/0Leconomictimes0Bindiatimes0N0Cnews0Cnri0Cvisa0Eand0Eimmigration0Cindians0Evisiting0Euk0Ecan0Enow0Etravel0Eto0Eireland0Ewithout0Evisa0Carticleshow0C90A77690A0Bcms/story01.htm
(The above cell is not a hyperlink, only a text written in a cell)

This way the entire column A & B goes on with the following text.

Hyperlinks of the range stands for Col B.

Additionally i want as soon as the link on the userform is clicked, then webbrowser to be opened in the same userform displaying the content.

Thanks!