ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Command Button Problem (https://www.excelbanter.com/excel-programming/283269-command-button-problem.html)

del

Command Button Problem
 
Hi all,

Is there a way to open up a webpage in Internet Explorer from a command button
on a userform?

I was hoping to add a link to a page on a website directly from a button on a
switchboard I am building.

TIA

Del.

Chip Pearson[_2_]

Command Button Problem
 
Del,

Try something like the following:

Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink "http://www.cpearson.com"
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"del" wrote in message
...
Hi all,

Is there a way to open up a webpage in Internet Explorer from a command

button
on a userform?

I was hoping to add a link to a page on a website directly from a button

on a
switchboard I am building.

TIA

Del.




del

Command Button Problem
 
Thanks Chip, that works like a charm.

I appreciate your help.

Tom Ogilvy

Command Button Problem
 
look at the followhyperlink method.

--
Regards,
Tom Ogilvy

"del" wrote in message
...
Hi all,

Is there a way to open up a webpage in Internet Explorer from a command

button
on a userform?

I was hoping to add a link to a page on a website directly from a button

on a
switchboard I am building.

TIA

Del.





All times are GMT +1. The time now is 04:39 AM.

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