| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button Hyperlink
Thanks for taking the time to read my question.
Is it possible to have a button on a form act as a hyperlink? If so, how do I do this? Thanks, Brad |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command Button Hyperlink
You can use a textbox from the Drawing toolbar, Brad.
******************* ~Anne Troy www.OfficeArticles.com "Brad" wrote in message ... Thanks for taking the time to read my question. Is it possible to have a button on a form act as a hyperlink? If so, how do I do this? Thanks, Brad |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command Button Hyperlink
You can use that on a user form?
Brad "Anne Troy" wrote: You can use a textbox from the Drawing toolbar, Brad. ******************* ~Anne Troy www.OfficeArticles.com "Brad" wrote in message ... Thanks for taking the time to read my question. Is it possible to have a button on a form act as a hyperlink? If so, how do I do this? Thanks, Brad |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command Button Hyperlink
Sorry, Brad. No.
******************* ~Anne Troy www.OfficeArticles.com "Brad" wrote in message ... You can use that on a user form? Brad "Anne Troy" wrote: You can use a textbox from the Drawing toolbar, Brad. ******************* ~Anne Troy www.OfficeArticles.com "Brad" wrote in message ... Thanks for taking the time to read my question. Is it possible to have a button on a form act as a hyperlink? If so, how do I do this? Thanks, Brad |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command Button Hyperlink
How about something like:
Option Explicit Private Sub CommandButton1_Click() ThisWorkbook.FollowHyperlink Address:="http://www.yoursite.com" End Sub You might want to do the same thing with a label--format it blue underline so that it looks like a hyperlink. It might be more familiar to users. Brad wrote: Thanks for taking the time to read my question. Is it possible to have a button on a form act as a hyperlink? If so, how do I do this? Thanks, Brad -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command Button Hyperlink
PERFECT!!
Thanks so much Dave, Brad "Dave Peterson" wrote: How about something like: Option Explicit Private Sub CommandButton1_Click() ThisWorkbook.FollowHyperlink Address:="http://www.yoursite.com" End Sub You might want to do the same thing with a label--format it blue underline so that it looks like a hyperlink. It might be more familiar to users. Brad wrote: Thanks for taking the time to read my question. Is it possible to have a button on a form act as a hyperlink? If so, how do I do this? Thanks, Brad -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| put a hyperlink on a command button | Excel Worksheet Functions | |||
| Command Button Hyperlink | Excel Discussion (Misc queries) | |||
| Command Button to Hyperlink to a Different worksheet | Excel Programming | |||
| How do I execute command from button or hyperlink? | Excel Discussion (Misc queries) | |||
| setting a command button to be a hyperlink | Excel Programming | |||
Linear Mode
