TextBox Hyperlink Code

[oskar44]

I have a textbox “txtLink” in my userform which shows all the hyperlinks from a dB. When I click on the link nothing happens

Is there a property I’m missing to have the link open when I click on it or I need a code?

Thank you

[Norie]

The value in a textbox is just text, it's not a hyperlink.

What exactly are you trying to do and why multiple values/hyperlinks in one textbox?

[oskar44]

Thanks Norie for the help. I have a table with 4 columns and the headers are “Category, WebAddress, Link, ID). When I click on any link in the table, it takes me to that link.

I understand that the textbox is just text but I have a similar situation in another workbook where the text is Email and when I click on the email it takes me to my Email program which is what I want

The code for this was provided by a member on this forum and it is like that

Please Login or Register  to view this content.

I think If I could replace in the above code the “mailto” to something appropriate it should work

[Norie]

Just get rid of "mailto:" & and change txtEmail to the name of the textbox that has the link you want to navigate to.

For example,

Please Login or Register  to view this content.

or perhaps.

Please Login or Register  to view this content.

[oskar44]

I get "Syntax error" or "Expected: end of statement" but now you gave me the idea I try different statements to see if it will work

[Norie]

That code was a bit rough and, unfortunately, untested.

Try playing about with it but if you don't have any luck attach a sample workbook so we can see what you are working with.

[oskar44]

Thanks Norie, I will give it a try

[oskar44]

This code is working here (txtLINK is the name of my textbox)

Please Login or Register  to view this content.