+ Reply to Thread
Results 1 to 21 of 21

Hyperlink text to image

Hybrid View

  1. #1
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Hyperlink text to image

    add target.value to the line

    Shell ("RunDLL32.exe C:\Windows\System32\Shimgvw.dll,ImageView_Fullscreen " & FilePath & Target.Value)

    ps you should probably target column as well
    If Target.Column < 14 Or Target.Column > 17 Then Exit Sub
    just so it doesn't run when you select column R on wards
    Last edited by humdingaling; 07-18-2018 at 08:47 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  2. #2
    Forum Contributor
    Join Date
    06-10-2012
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    132

    Re: Hyperlink text to image

    Quote Originally Posted by humdingaling View Post
    add target.value to the line

    Shell ("RunDLL32.exe C:\Windows\System32\Shimgvw.dll,ImageView_Fullscreen " & FilePath & Target.Value)

    ps you should probably target column as well
    If Target.Column < 14 Or Target.Column > 17 Then Exit Sub
    just so it doesn't run when you select column R on wards
    Dear Humdingaling

    tried the lines of code that you suggested but nothing happens,

    any ideas why this would be?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Inserting image into userform label, text behind image?!?!
    By spyrule in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-31-2016, 03:23 PM
  2. VBA: Put text from excel to jpeg image by matching image name.
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2013, 01:47 AM
  3. Replies: 5
    Last Post: 06-18-2013, 11:54 PM
  4. Connect image to hyperlink (web URL)
    By Nostalgia80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2013, 11:01 AM
  5. Adding Image into a excel cell and adding a hyperlink to the image
    By saravananiyyanar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2011, 04:16 AM
  6. Need Help-Add Image to a hyperlink
    By Ashish82 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2008, 06:09 PM
  7. Hyperlink to an image in other worksheet, displaying entire image.
    By twilliams in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2006, 06:10 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1