+ Reply to Thread
Results 1 to 17 of 17

Insert Signature Upon Choosing Name

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Insert Signature Upon Choosing Name

    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.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Insert Signature Upon Choosing Name

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

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,656

    Re: Insert Signature Upon Choosing Name

    See http://www.mcgimpsey.com/excel/lookuppics.html
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Re: Insert Signature Upon Choosing Name

    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.

  5. #5
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Re: Insert Signature Upon Choosing Name

    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.

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Insert Signature Upon Choosing Name

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

    Please Login or Register  to view this content.
    ...and the pictures will be unhidden, but as soon as you run the code again the pictures will hide.
    HTH
    Regards, Jeff

  7. #7
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Re: Insert Signature Upon Choosing Name

    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?

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Insert Signature Upon Choosing Name

    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

  9. #9
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Re: Insert Signature Upon Choosing Name

    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.
    Attached Files Attached Files
    Last edited by swordswinger710; 03-26-2012 at 02:20 PM.

  10. #10
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Insert Signature Upon Choosing Name

    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.

  11. #11
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Re: Insert Signature Upon Choosing Name

    Great, that fixes that issue. So, would the code work for my situation?
    Last edited by swordswinger710; 03-26-2012 at 02:43 PM.

  12. #12
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Re: Insert Signature Upon Choosing Name

    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?

  13. #13
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Insert Signature Upon Choosing Name

    I don't see why not, what have you tried or what is failing?

  14. #14
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Re: Insert Signature Upon Choosing Name

    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.

  15. #15
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Insert Signature Upon Choosing Name

    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.

  16. #16
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Re: Insert Signature Upon Choosing Name

    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?

  17. #17
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Re: Insert Signature Upon Choosing Name

    I see the upload issue is still persistent - any ideas for my situation?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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