+ Reply to Thread
Results 1 to 1 of 1

ActiveX Image changed with selected record

  1. #1
    Registered User
    Join Date
    08-24-2014
    Location
    Edmonton, Alberta
    MS-Off Ver
    2016-64 bit & Win 10
    Posts
    8

    ActiveX Image changed with selected record

    This should be simple, but it eludes me ...

    I select an album name, and it populates my (ActiveX?) form. (It's not a userform, it's the form one builds directly on a worksheet). The album cover image is in a dedicated folder, and has a simple 5 digit file name. So the populated image name is "12345", which I can concatenate into a full file name such as "C:\AlbumCovers\12345.jpg" (the directory is a separate item to allow me to move the images to a different location).

    So all I want to do is have the image change as a new record is selected, but I'm stumped on the how-to. No search seems to address this. Logically, I would expect to plug in a cell name (ImageName) at the property 'Picture' (which only allows one to select an image which remains static)

    Suggestions?
    Last edited by bbelly; 01-16-2018 at 02:35 PM. Reason: more info

+ 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. Getting macro to run when ActiveX combo box is changed
    By bneed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2016, 04:10 PM
  2. [SOLVED] Using a Userform to Browse image file then paste selected image to sheet?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2015, 05:42 PM
  3. [SOLVED] Pasting an image into selected merged cells. VBA to size automatically to selected range
    By DCC_PD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2015, 09:57 AM
  4. [SOLVED] Linking Image to a cell value, and display the selected image in new sheet
    By siva venkata in forum Excel General
    Replies: 12
    Last Post: 03-25-2014, 02:34 AM
  5. [SOLVED] ActiveX image and size of file
    By Kiwoop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 10:25 AM
  6. Displaying and Updating Image Dynamically (ActiveX Image Control?)
    By VTHokie11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2011, 10:57 AM
  7. Image Position within ActiveX Image Control
    By gerryiscool in forum Excel General
    Replies: 0
    Last Post: 09-07-2011, 02:08 AM

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