ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hyperlink button on a userform (https://www.excelbanter.com/excel-programming/436784-hyperlink-button-userform.html)

Roger on Excel
hyperlink button on a userform
 
[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?

Rainer Bielefeld
hyperlink button on a userform
 
Hi Roger,

try

ActiveWorkbook.FollowHyperlink txtHyperlink1.value

Regards,

Rainer

"Roger on Excel" schrieb im Newsbeitrag
...
[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?


All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com