Multiple hyperlinks in a single cell
- Thread starter GaryA
- Start date
Hi Ken,
I need to modify the "CheckAndColorLinks" routine to add the specific value of FaceID when a link is good or bad.
How do you pass that value to the Worksheet_SelectionChange(ByVal Target As Range).
The .FaceIDs I will be using are 2876 and 6843, passed to variable iICON
i.e.
Thanks,
Gary
I need to modify the "CheckAndColorLinks" routine to add the specific value of FaceID when a link is good or bad.
How do you pass that value to the Worksheet_SelectionChange(ByVal Target As Range).
The .FaceIDs I will be using are 2876 and 6843, passed to variable iICON
i.e.
Code:
With Application.CommandBars("Cell").Controls
With .Add
.Caption = Hyp1 'Navigate to Hyperlink1
.OnAction = ThisWorkbook.Name & "!Nav_Hyp1" 'in RClick
.Tag = "Hyperlink1" 'cControlTag
.BeginGroup = True
.FaceID = iICON
End With
End WithThanks,
Gary
- Joined
- Mar 13, 2011
- Messages
- 2,531
- Reaction score
- 6
- Points
- 38
- Location
- Nanaimo, BC, Canada
- Website
- www.excelguru.ca
- Excel Version(s)
- Excel Office 365 Insider
Hey Gary,
I haven't forgotten, but I'm out of time for tonight. I'll try and circle back on this over the weekend, although it's kind of a nutty one here.
FYI... I've reformatted your code to display better in the forum. When you're posting code, if you wrap it with code tags it comes out looking nicer. To do that, you'd write:
[code]Your code here[/code]
And it will end up coming out like this:
Cheers,
I haven't forgotten, but I'm out of time for tonight. I'll try and circle back on this over the weekend, although it's kind of a nutty one here.
FYI... I've reformatted your code to display better in the forum. When you're posting code, if you wrap it with code tags it comes out looking nicer. To do that, you'd write:
[code]Your code here[/code]
And it will end up coming out like this:
Code:
Your code hereCheers,