hyperlink button on a userform

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
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?
 
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

VBA userform Vlookup Excel 1
Copy hyperlinks 6
Hyperlink to show a userform 2
modeless userform 4
Hyperlinks on UserForm 1
Hyperlink to a userform? 2
Command button - check listbox contents before activating? 3
Hyperlink in Commandbutton 4

Back
Top