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

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

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

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

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

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