Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a way to change what is displayed on a hyperlink in vb code? I
would like for a input box to appear and ask what name would you like to call the link? Thanks Greg |
#2
![]() |
|||
|
|||
![]()
the macro recorder is your friend
Sub Macro5() ' ' Macro5 Macro ' Macro recorded 9/16/2005 by Don Guillett ' ' Selection.Hyperlinks(1).TextToDisplay = "my yahoo 11" End Sub now change to Selection.Hyperlinks(1).TextToDisplay = inputbox("enter name")'"my yahoo 11" -- Don Guillett SalesAid Software "Greg B" wrote in message ... Is there a way to change what is displayed on a hyperlink in vb code? I would like for a input box to appear and ask what name would you like to call the link? Thanks Greg |
#3
![]() |
|||
|
|||
![]()
thanks Don
"Don Guillett" wrote in message ... the macro recorder is your friend Sub Macro5() ' ' Macro5 Macro ' Macro recorded 9/16/2005 by Don Guillett ' ' Selection.Hyperlinks(1).TextToDisplay = "my yahoo 11" End Sub now change to Selection.Hyperlinks(1).TextToDisplay = inputbox("enter name")'"my yahoo 11" -- Don Guillett SalesAid Software "Greg B" wrote in message ... Is there a way to change what is displayed on a hyperlink in vb code? I would like for a input box to appear and ask what name would you like to call the link? Thanks Greg |
#5
![]() |
|||
|
|||
![]()
It works great Have made little changes with your code. I tried the macro
builder but it remained blank. Thanks again Greg "Don Guillett" wrote in message ... glad to help -- Don Guillett SalesAid Software "Greg B" wrote in message ... thanks Don "Don Guillett" wrote in message ... the macro recorder is your friend Sub Macro5() ' ' Macro5 Macro ' Macro recorded 9/16/2005 by Don Guillett ' ' Selection.Hyperlinks(1).TextToDisplay = "my yahoo 11" End Sub now change to Selection.Hyperlinks(1).TextToDisplay = inputbox("enter name")'"my yahoo 11" -- Don Guillett SalesAid Software "Greg B" wrote in message ... Is there a way to change what is displayed on a hyperlink in vb code? I would like for a input box to appear and ask what name would you like to call the link? Thanks Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find function | Excel Worksheet Functions | |||
Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
Execute Macro automatically after hyperlink | Excel Discussion (Misc queries) | |||
Where to stick macro to change default comment font? | Excel Discussion (Misc queries) | |||
Macro button colour change??? | Excel Worksheet Functions |