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

**DocAElstein** · 02-03-2023, 08:19 PM

Originally Posted by txjackknife

Thank You. ....I tried to delete everything on the excel file except what is needed and it was still too large.....
https://app.box.com/s/6txll6kxefi4q6ld08gfepftdxre36k7

**txjackknife** · 02-03-2023, 10:22 PM

Originally Posted by DocAElstein

.....aken a quick look at the file, and when I open it I see this:
https://i.postimg.cc/4NFPtzWz/Signatures.jpg
Signatures.JPG
At first glance I am not quite sure what is going on , or what should happen. Remember you know about this file so any short description, as you gave in your first post, will sound perfectly OK to you for to explain what the problem and to explain what you want. For someone like me seeing the file for the first time it is not immediately obvious what is going on.-----------

So when you go to the COR-Cover sheet and click on the drop down menu and select a name, it is supposed to insert that persons signature from the signature sheet. It works on some names but not others and I am not savy enough to figure out what needs corrected. Several names were added to the list both on the COR-Cover sheet to the right I believe column AA as well as the signature sheet. The Pending COR sheet does not work as it should either. It should function the same as the COR-Cover sheet. I hope this makes sense.

Thank you

**DocAElstein** · 02-04-2023, 04:42 AM

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).

**txjackknife** · 02-07-2023, 02:07 AM

Thank you so much for your help with this. With what you figured out and the screenshots you sent, I was able to figure out what to do to make this all work!

Much appreciated!
Brian