+ Reply to Thread
Results 1 to 21 of 21

Hyperlink text to image

Hybrid View

didierkassas Hyperlink text to image 07-05-2018, 08:04 AM
davesexcel Re: Hyperlink text to image 07-05-2018, 01:54 PM
didierkassas Re: Hyperlink text to image 07-09-2018, 04:11 AM
davesexcel Re: Hyperlink text to image 07-09-2018, 08:03 AM
didierkassas Re: Hyperlink text to image 07-09-2018, 08:09 AM
davesexcel Re: Hyperlink text to image 07-09-2018, 09:28 AM
didierkassas Re: Hyperlink text to image 07-09-2018, 09:31 AM
davesexcel Re: Hyperlink text to image 07-09-2018, 09:31 AM
didierkassas Re: Hyperlink text to image 07-10-2018, 12:28 AM
didierkassas Re: Hyperlink text to image 07-11-2018, 12:44 AM
humdingaling Re: Hyperlink text to image 07-11-2018, 08:43 AM
didierkassas Re: Hyperlink text to image 07-15-2018, 12:51 AM
humdingaling Re: Hyperlink text to image 07-15-2018, 09:00 PM
didierkassas Re: Hyperlink text to image 07-16-2018, 12:19 AM
humdingaling Re: Hyperlink text to image 07-16-2018, 08:03 PM
didierkassas Re: Hyperlink text to image 07-17-2018, 01:13 AM
humdingaling Re: Hyperlink text to image 07-18-2018, 08:43 PM
didierkassas Re: Hyperlink text to image 07-19-2018, 12:48 AM
humdingaling Re: Hyperlink text to image 07-19-2018, 04:14 AM
didierkassas Re: Hyperlink text to image 07-19-2018, 04:33 AM
humdingaling Re: Hyperlink text to image 07-19-2018, 04:51 AM
  1. #1
    Forum Contributor
    Join Date
    06-10-2012
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    132

    Re: Hyperlink text to image

    Dear Humding

    we are nearly there

    i actually needed to have the file path as i want to refer to a specific cell as the location of the images may change
    so i changed the code as per the below



    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim sh As Worksheet
    Dim PcRng As Range
    Dim rng As Range
    Dim strFile As String

    Set sh = Sheets("Accreditation")

    If Target.Column < 14 Then Exit Sub
    If Target.Row < 4 Then Exit Sub

    'Assume this is fixed
    FilePath = ActiveSheet.Range("u1").Value


    'load external viewer
    Shell ("RunDLL32.exe C:\Windows\System32\Shimgvw.dll,ImageView_Fullscreen " & FilePath)

    End Sub



    it works in the sence that if i change the path then the image still shows, the problem now is that it always shows the same image instead of changing . i have attached the Excel
    Attached Files Attached Files

+ 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