-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
texttodisplay
-
C
Hyperlink cell
Hi I need help, I need a VBA that any cell in Column "E" that starts with “https:*” becomes an Active Hyperlink and displays as “Link to Site” and all cells do not become Hyperlinks and are unchanged. I have tried a few methods (one below) but all convert all cells in E Column to Hyperlinks...- Cooky857
- Thread
- hypelink texttodisplay vba
- Replies: 8
- Forum: Excel Questions
-
D
Modifying a Hyperlink SubAddress
I am trying to modify an existing hyperlink from a VBA macro The existing link is in cell B1 (B1 through H1 are merged to fomB1 if that makes a difference) of worksheet("TestSheet") I want to change the existing subaddress from whatever it is to "UI!A", and the TextToDisplay from whatever it...- dbodimer
- Thread
- existing hyperlink subaddress texttodisplay uia
- Replies: 1
- Forum: Excel Questions
-
J
VBA using a formula in text to display
I am trying to set the Hyperlink texttodisplay property in VBA to a formula to return a cell value from a different sheet using INDRECT, the code I am using is; TextToDisplay:="=INDIRECT(""'"" & R6C1 & ""'!A1"")" The formula will go into cell B6 so "R6C1" refers to A6. But this does not...- Jimbola
- Thread
- cell correct formula texttodisplay vba
- Replies: 1
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
