ExcelBanter - Assigning a Hyperlink to a CommandButton

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Assigning a Hyperlink to a CommandButton (https://www.excelbanter.com/excel-discussion-misc-queries/2301-assigning-hyperlink-commandbutton.html)

Andy T

Assigning a Hyperlink to a CommandButton

Is it possible to assign a hyperlink to a commandbutton in VB so that when it
is clicked the webpage is opened?

Many thanks as always.
--
Andy T

Frank Kabel

Hi
not directly possible. But you can put some code in the click event of your
command button. see:
http://j-walk.com/ss/excel/tips/tip71.htm

"Andy T" wrote:

Is it possible to assign a hyperlink to a commandbutton in VB so that when it
is clicked the webpage is opened?

Many thanks as always.
--
Andy T

Andy T

Many thanks Frank, this works perfectly.

Regards

"Frank Kabel" wrote:

Hi
not directly possible. But you can put some code in the click event of your
command button. see:
http://j-walk.com/ss/excel/tips/tip71.htm

"Andy T" wrote:

Is it possible to assign a hyperlink to a commandbutton in VB so that when it
is clicked the webpage is opened?

Many thanks as always.
--
Andy T

All times are GMT +1. The time now is 02:28 PM.