Page 3 of 3 FirstFirst 1 2 3
Results 21 to 23 of 23

Thread: Multiple hyperlinks in a single cell

  1. #21


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Adding good/bad icons to the Rt mouse click menu is a great idea. I'll give it a go.

    Many Thanks,

    Gary

  2. #22
    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.

    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 With
    Thanks,

    Gary

  3. #23
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,344
    Articles
    57
    Blog Entries
    14
    Excel Version
    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:
    Code:
    Your code here
    Cheers,
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Page 3 of 3 FirstFirst 1 2 3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •