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![]()
Bookmarks