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

You can use a textbox from the Drawing toolbar, Brad.
*******************
~Anne Troy

www.OfficeArticles.com


"Brad" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

Sorry, Brad. No.
*******************
~Anne Troy

www.OfficeArticles.com


"Brad" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >

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

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
>