Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign macro and hyperlink | Excel Programming | |||
Assign a macro to a hyperlink | Excel Programming | |||
Assign a macro to a hyperlink | Excel Programming | |||
How can I assign a symbol to a button (like the $ button) | Excel Discussion (Misc queries) | |||
how to Assign Hyperlink to Button in Spreadsheet | Excel Discussion (Misc queries) |