hyperlink button on a userform

R

Roger on Excel

[excel 2003]
I have a userform which has a column of textboxes displaying hyperlink
addresses pulled from a vlookup table. The text boxes have the names :

txtHyperlink1
txtHyperlink2
txtHyperlink3

I have Command buttons next to these boxes to which I would like to add code
such that they call up the web for the listed hyperlink shown in the text
boxes.

Can anyone help?
 
R

Rainer Bielefeld

Hi Roger,

try

ActiveWorkbook.FollowHyperlink txtHyperlink1.value

Regards,

Rainer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
How do I set focus (and select text) on a text box on a modeless userform? 0
I figured out the issue thank you. 0
Optionbutton Not working 3
AppleScript - How do I select a text ? 1
Creating a Search using a combo box and then creating a report. 4
Odd behaviour with a userform 0
Userform Calculation 4

Top