Dropdown menu that inserts signature Picture from selected name: Not always working or gets wrong picture

[DocAElstein]

Continued from last post ………

OK, so I don’t know how to sort out that messed up order , (at least not in some easy automated conventional “proper way” , assuming there is one – I expect fiddling around manually would probably do it).
I will try a different approach: I will see if I can insert somehow a picture into worksheet signatures, and then get things to do like you want with it.




_1) Insert a picture into Excel. I had no idea. So I Googled. There are hundreds of Blogs and YouTube videos that explain it a lot better than I can. So I followed a few and was able to insert a small picture of a fox, that was sitting wagging its tail on my desktop, into worksheet signatures
https://i.postimg.cc/FRTQmRHc/Insert...signatures.jpg

_2) I re ran that macro I wrote, and you can see it is showing a new entry , which Excel has given the name Picture 8
https://i.postimg.cc/T3bGmftM/New-Entry-Picture-8.jpg
( So I assume that Picture 8 is some number name thing given by Excel automatically when you insert a picture into Excel, but I don’t know for sure. I never did anything like this before! - My guess is that if I put another picture in , then Excel will give it the name number Picture 9 )

_3) So I write in Fox and Picture 8
https://i.postimg.cc/xTc9fKHd/write-...-Picture-8.jpg
and
_4 ) I write in Fox
https://i.postimg.cc/mrQLxB9N/write-in-Fox.jpg

Don’t ask me why I did steps _3) and _4) . I don’t know really. It just seemed like a good idea at the time, Lol! It seems to make some sense even though I don’t really know what I am doing here..

_5) I notice that Fox is not in the drop down list yet… I don’t know about drop down lists, I never used them. But apparently it has something to do with data validation, what ever that is. I fiddled around and found this thing
https://i.postimg.cc/Kc9Zh91V/Drop-d...ods-wollop.jpg
(note: I had cell B42 selected while i was fiddling about )

_6) I changes 47 to 48 because that Fox is in cell AA48. ( I wrote it there in step _4) )
https://i.postimg.cc/s2Fj0vMg/Changed-47-to-48.jpg

_7) Fox is now in the drop down list. https://i.postimg.cc/K83cNnvW/Fox-appears.jpg
Select it….
Bingo!
https://i.postimg.cc/vHNHfPM9/Bingo-Full-Fox.jpg
_._______________________________

So I think that has shown a way to get what you want, at least one way.

I expect a macro could be written to go through a set of pictures in a folder somewhere and bring them in and do all that stuff for all of them. I probably could not do it very quickly as I am new to a lot of the stuff here, but someone with more experience of playing around with pictures in excel could probably do it a bit easier.


See how you get on with all that,

Alan

---

---

Edit
Here just some temporary conclusions and remarks. They are based on my initial experiments so bear that in mind. There could be more to it, depending on what the full workbook is all about

_a) It looks like the column AA in worksheet COR-Cover is used to fill the drop down list. Without knowing too much aboput drop down lists and data validation stuff, I think you can figure out from these screenshots that I have it currently set to the range AA38 – AA48
https://i.postimg.cc/9fbtL7vy/Column...-COR-Cover.jpg
https://i.postimg.cc/fLb7pbNp/Column...-COR-Cover.jpg
https://i.postimg.cc/MTr0S8ZT/Column...-COR-Cover.jpg

_b) The two column list top left in worksheet Signatures is used to match up two things:
_column B, the
Picture x ( where x is 1 2 3 4 …. Etc … )
That being the name given by Excel to an inserted picture,
_column A: the name you choose to give it, the picture that Excel calls Picture x . I chose Fox, for example, for the picture I inserted, which Excel decided to call Picture 8 .
You obviously want to give the name of the name in the signature.

The crux of your problem seems to be that things have possibly been added a bit randomly , possibly also some things taken out, and that has resulted in a muddle with the lists

What I have basically done in this and the previous post is to show one way of how to figure out what name given by Excel relates to which signature picture already in the worksheet. I did it for the first time and wrote the post as I went along. So it may not be totally clear. See how you get on, and if you need more clarity, ask, and I will take another look, ( may not be for a day or two).