View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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