+ Reply to Thread
Results 1 to 3 of 3

Digital Signatures - Move "pictures" depending on certain cell value

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Goteborg, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    15

    Question Digital Signatures - Move "pictures" depending on certain cell value

    Hello,
    Working in Excel 2010..

    Currently working on a report, which should be sent to clients directly from Excel.
    By the end of my current code, I would like the macro to add a sort of "waterstamp" (a picture) which will be used as a digital signature.
    The macro must identify which picture to move to the report, depending on the name of the user who created the report (manual input by user)

    Ex.
    I'm creating the report:

    In cell M2 I enter my name "Joakim Svensson".
    Based on this, the macro must find my picture (named: JSV) and copy from wks3 to wks"report" to cell I1.

    In case Mr X creates the report:
    In cell M2 he will enter "MRX"
    Then macto shall find the picture named "MRX" and copy to worksheet "report" range I1.

    (Even better would be if the code also could secure that the picture is sized as per the cell..)

    I've googled alot, and tried many different codes - but I'm not able to get the functionality I need.
    Do you know if this is possible, if so - how?
    Anyone who might have a sample code I can try - or even better, a code which would do all this for me

    Many thanks in advance // Joakim

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Digital Signatures - Move "pictures" depending on certain cell value

    hi Jock3, sort of option: formula + VB, foto search is done by formula, fitting the cell size is done by VB in sheet Main, change cell B3 to check result in C22
    PS. If the foto do not resize to the cell size, run code "EnableEvent" and try again
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-21-2013
    Location
    Goteborg, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Digital Signatures - Move "pictures" depending on certain cell value

    Hi,
    Actually found a VERY convenient solution as per attached sheet.

    I wont even have to use VBA, but simply select name in a dropdown which will show my picture
    wherever I place the frame of where to show it - can move it around freely.

    Can suggest it others, and thank the "craetor" for sharing this solution!

    B regards // Joakim
    Attached Files Attached Files

+ 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