Another question:
If Cell A1 has a drop down list with a bunch of names, and the name John Carter is chosen; is Excel able to display his signature in Cell B1?
Another question:
If Cell A1 has a drop down list with a bunch of names, and the name John Carter is chosen; is Excel able to display his signature in Cell B1?
Last edited by Paul; 03-23-2012 at 05:37 PM.
There is so much good in the worst of us,
And so much bad in the best of us,
That it hardly behooves any of us
To talk about the rest of us.
Hi swordswinger710, I'm sure this can be done but where is his signature relative to his name? Is the whole sheet formatted the same way?
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Entia non sunt multiplicanda sine necessitate
Mordred, thanks for your response - my workbook is set up so that there's an Entry Page. The cells therein send data to cells on multiple sheets in this workbook. Four of these data cells require a name, and these four names need to display their respective signatures in the cells on the sheets they're linked to. If the Entry Page name gets switched to another dude, then the old signature needs to get replaced with the new signature.
Does this make sense? I don't know where to put the signatures it's supposed to grab, but I suppose a list on the Entry Page will do...
shg, thank you, I will check that out.
shg, I've downloaded that sample file, and I think this method will work, but where on earth are the actual pictures located? I'm stumped.
The pictures are being hidden by the code. From what I can see, they are hidden in the top left cornor of Sheet1.
Run this...
...and the pictures will be unhidden, but as soon as you run the code again the pictures will hide.Please Login or Register to view this content.
HTH
Regards, Jeff
jeffreybrown, thanks so much - so do you think there would be a way of actually having a list of pictures somewhere, so any new ones could be added easily?
Not a problem. Here is what I did to add new pictures
Step 1. Insert new pictures to Sheet1 (resize if necessary)
Step 2. On Sheet2, update PicTable with Name and Picture Name, but don't forget to resize the table range (Ctrl + F3)
Step 3. Back on Sheet1, select a new value from A2 and all pictures besides that which matches A2 will be hidden
Okay cool, I see what you're doing there - my workbook is a bit of a different case though I'm afraid, as you can see by my attachment below...
I also need the cells that receive the signature images to be empty if no name on the Entry Page is selected.
Last edited by swordswinger710; 03-26-2012 at 02:20 PM.
You can change the Vlookup too...
=IFERROR(VLOOKUP(A2, PicTable, 2, FALSE),"") (This is based on the original file setup from the sample workbook, because in the posted file I don't see any pictures or code you have attempted thus far)
...this way when you blank out the name the Vlookup that generates an error will now show "", therefore, no picture.
Great, that fixes that issue. So, would the code work for my situation?
Last edited by swordswinger710; 03-26-2012 at 02:43 PM.
I've been trying to attach an updated sample with signature images, but I keep getting upload errors. Does my sample in Post #9 give enough information?
I don't see why not, what have you tried or what is failing?
The code works well for one sheet, but I don't know how to edit it to display the signature on those other sheets in my example.
Sorry but I can't really make heads-or-tails out of your attachment.
I see the different names on the "Entry Page" tab, but have no idea about the 5Ws (Who, What, Where, When, and Why?
I'm going to need a few more details to get us further down the road and with what you have tried so far.
This upload issue is quite a bother right now, but it would basically be the same attachment plus a picture of each persons' signature next to their name on the value sheet.
If the four values on the Entry Page are empty, then all the cells that are linked to those cells (specified by the different colours from Page 1 through 5) would not display anyone's signature. If the fields get names, then their signature picture would be displayed in the cells marked with the same colour on the following sheets.
I haven't got any further than the example we have so far. I apologize if I wasn't clearer on this earlier. Does this make a bit of sense?
I see the upload issue is still persistent - any ideas for my situation?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks