How to assign a hyperlink to a button on a form?
 

I'm creating an order form and want to place buttons next to products that,
when clicked, take the user to a web page describing the product. I've found
a button icon on the "Forms" toolbar, but I'm not adept at VB programming and
I can't figure out how to attach or associate a hyperlink to a button. Any
advice would be appreciated!

Thanks,

Bremser

How to assign a hyperlink to a button on a form?
 

Why not just add an autoshape and assign the hyperlink to that.
--
HTH,
Barb Reinhardt



"Bremser" wrote:

I'm creating an order form and want to place buttons next to products that,
when clicked, take the user to a web page describing the product. I've found
a button icon on the "Forms" toolbar, but I'm not adept at VB programming and
I can't figure out how to attach or associate a hyperlink to a button. Any
advice would be appreciated!

Thanks,

Bremser

How to assign a hyperlink to a button on a form?
 

First create a Forms button
Next create a macro like:

Sub dural()
ActiveWorkbook.FollowHyperlink Address:="http://www.cnn.com"
End Sub

Last right-click the button and assign the macro.
--
Gary''s Student - gsnu200775


"Bremser" wrote:

I'm creating an order form and want to place buttons next to products that,
when clicked, take the user to a web page describing the product. I've found
a button icon on the "Forms" toolbar, but I'm not adept at VB programming and
I can't figure out how to attach or associate a hyperlink to a button. Any
advice would be appreciated!

Thanks,

Bremser