Results 1 to 6 of 6

Changing images with userform and VLOOKUP? Not sure

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Changing images with userform and VLOOKUP? Not sure

    Okay need some advice and very possibly some help. I have an area of 3 columns and we will say M17 has an image N17 has CIS120 and O17 Has Computer Concepts. There is one of these down to Row 26.

    I am trying to figure out a way to change the image in M17 to M26 column. I tried a dropbox using Complete,Not Complete, In Progress, and Mandatory but problem was it showed that term when the box wasnt selected and was out of place didnt go with the layout. Is it possible to do this with VBA there is 3 pictures and a * in a sheet called images The names are in A2:A5 and the images are B2:B5. I was thinking a userform that looked like this Crazy Idea.PNG but that I think would be a nightmare to code all the checkboxes. Is there a way to populate the form with what is in range M17:O26 and use a dropdown with the term to match the image and it update the image? OR is it possible to ?? I am at a lose on how to approach this. Can someone possibly give an idea(s) of what would be a good approach? Here is a picture Crazy Idea2.PNG of the layout and how the images are. Would be nice if a image could be inserted in a dropdown box and then I would just need to select the image.

    Thank you hopefully someone understands what I am asking or has a decipher ring for Gibberish to English
    Last edited by Mr_Bill; 09-30-2014 at 01:57 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Load Images from Userform/ Rebuild Userform
    By zimbo109 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-07-2013, 04:16 AM
  2. [SOLVED] Swap images depending on text in cell (vlookup for images??)
    By ld2x07 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-06-2013, 10:32 AM
  3. Changing Linked Images into Embedded Images
    By ericjover in forum Excel General
    Replies: 0
    Last Post: 01-05-2009, 02:23 PM
  4. changing images to symbols
    By fairlane73 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-27-2007, 03:40 PM
  5. Userform problem, bordercolor not changing around images
    By spyd3r in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 09:25 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