| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink on a label in a VB Form
Hi everyone,
I am having a splash screen appear upon workbook_open and there is a label with an email address that I would like users to be able to click that it hyperlinks to the email address. Anyone can help me with this? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink on a label in a VB Form
Are you showing a userform as that splash screen?
If yes, put a label on that userform and add some text and make it look like a hyperlink address (blue text and underlined). Then use the label's click event: Option Explicit Private Sub Label1_Click() ActiveWorkbook.FollowHyperlink Address:="http://www.microsoft.com" End Sub Gaetan wrote: Hi everyone, I am having a splash screen appear upon workbook_open and there is a label with an email address that I would like users to be able to click that it hyperlinks to the email address. Anyone can help me with this? Thanks. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink on a label in a VB Form
It gives me an error with an email address... Is the code to be different?
Thanks. "Dave Peterson" wrote: Are you showing a userform as that splash screen? If yes, put a label on that userform and add some text and make it look like a hyperlink address (blue text and underlined). Then use the label's click event: Option Explicit Private Sub Label1_Click() ActiveWorkbook.FollowHyperlink Address:="http://www.microsoft.com" End Sub Gaetan wrote: Hi everyone, I am having a splash screen appear upon workbook_open and there is a label with an email address that I would like users to be able to click that it hyperlinks to the email address. Anyone can help me with this? Thanks. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink on a label in a VB Form
Yep. Kind of. The code is the same. The address is different <bg.
ActiveWorkbook.FollowHyperlink " Gaetan wrote: It gives me an error with an email address... Is the code to be different? Thanks. "Dave Peterson" wrote: Are you showing a userform as that splash screen? If yes, put a label on that userform and add some text and make it look like a hyperlink address (blue text and underlined). Then use the label's click event: Option Explicit Private Sub Label1_Click() ActiveWorkbook.FollowHyperlink Address:="http://www.microsoft.com" End Sub Gaetan wrote: Hi everyone, I am having a splash screen appear upon workbook_open and there is a label with an email address that I would like users to be able to click that it hyperlinks to the email address. Anyone can help me with this? Thanks. -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink on a label in a VB Form
That's good... Thanks Dave!
"Dave Peterson" wrote: Yep. Kind of. The code is the same. The address is different <bg. ActiveWorkbook.FollowHyperlink " Gaetan wrote: It gives me an error with an email address... Is the code to be different? Thanks. "Dave Peterson" wrote: Are you showing a userform as that splash screen? If yes, put a label on that userform and add some text and make it look like a hyperlink address (blue text and underlined). Then use the label's click event: Option Explicit Private Sub Label1_Click() ActiveWorkbook.FollowHyperlink Address:="http://www.microsoft.com" End Sub Gaetan wrote: Hi everyone, I am having a splash screen appear upon workbook_open and there is a label with an email address that I would like users to be able to click that it hyperlinks to the email address. Anyone can help me with this? Thanks. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I re-number Excel Form Label Controls for orderly tabbing. | Excel Worksheet Functions | |||
| COPY LABEL FORM FROM EXCEL TO A LABEL | New Users to Excel | |||
| Hyperlink to specific Form in MSAccess | Excel Discussion (Misc queries) | |||
| How do I take excel data and convert to label/envelope form? | Excel Worksheet Functions | |||
| hyperlink images in batch form | Excel Worksheet Functions | |||
Linear Mode
