Can u input a signature or picture into a cell

Hi
I need to input signatures into cells automatically when a date is inputed into an adjecent cell. I have a scanned copy of a signature but because when u insert image it doesn't put it into a cell I can't just put =a1 as a1 is still empty.
Thank you

can you give some dummy examples of images
ideally create a file with how you want it to perform, even if you have to do everything manually for this example file

Not sure exactly what you want to see. The images I want to input are signatures which have been scaned in so I either need to be able to "tie in" an image to a cell so when I reference that cell it brings up the picture or be able to input a picture (the signature) as part of a formula i.e. if a1 = 28/01/14,insert picutre,"No date"

so images have a file name that matches the date ? like 280114.jpg ?
do you have a structure to the file naming of the files that can easily be matched to the value entered into A1 ?

No there isn't any structure to the image. Basically I have a training record. When someone adds a date to a sheet to log they have done training on a certain bit of kit that date is then automatically put into another sheet which is for printing out. When that date is put in the second sheet I want it to automatically put a signature in the cell next to the date. I have done this with standard txt from another cell but I need actual signatures. Hope that makes sence

but if there are a load of signature images available, how do we set the the conditions to make sure it's displaying the correct image ?

ah, there's only one signature?

For each sheet there is only one signature/image. So I will have one col some with dates some blank and then in the col next to that I want an image of a signature replicated down wherever there is a date.
From attachment where you have J.Bloggs I need a real signature in there.

Unfortunately, excel doesn't provide what you are after without extensive VBA coding

However, Google Sheets does offer what you are looking for

have a look at -> https://docs.google.com/spreadsheets...Uuk/edit#gid=0

I've only used a signature image found from a google search, but you could convert your excel file to google docs with this functionality
If you're not familiar with google sheets, I can guide you through it, and show how you can protect your files

Hi nappy1001 - I am brand new to this forum and your post was the first one I read.

I came looking for help with the same exact interest - capturing a signature in Excel 2010. I am not interested though in having images stored, I simply want to have a box available for the person to sign in - as is - on a Toughbook tablet pc. I ran across a company today that offers an Excel add-in and I believe they want to sell a signature pad to go with it - my wish is for the signature with the pen that comes with the Toughbook - without needing a Signature pad to make it work with Excel.

Not sure if this type of addin with hardware is the solution you are looking for or not.

Funny how we are looking for a very similar need.

Maybe this post will eventually help us both?
Thanks for sharing,
Rookie

Hi Thirty Two,

I am interested to know more about your solution by using VBA. I work with a lady who is very comfortable using VBA with Excel - in fact the application I need the signature for uses a lot of VBA already. Can you give me a point in the right direction as to how VBA could allow a user to sign in a signature box and it get captured?

Thanks for any suggestions!

did you look at the link i posted, it might give you more ideas
if that link doesn't suit your needs, yes I'd be happy to discuss with you how coding in VBA would give you the desired results

I just did look at the link - I am not a VBA guru or even Excel either - just know enough to recognize and follow along. It looks like you used a formula for cell A2 - is that correct?

there is no VBA knowledge required if you convert to Google Sheets

Hi Srodopol.
I'd love for my firm to buy that sort of Hardware but that isn't going to happen. Just want to able to put a signature into a cell, not bothered how it gets there but a scanned image seemed like the easiest option. I was hoping you could insert that into a cell but would seem you can't
Nappy1001

Hi ThirtTwo
Thank you for your input. Will defintly look into Googledocs to see if I can work the rest of the excel sheets to it and make it easilly accessable to everyone.

Neil

Hi ThirtyTwo
Thank you for your input. Will definatly look into the Googledocs but not sure its going to work for me. Can you think of anyother way to get a signature on to the computer and then be able to call it up in excel within a formula.
Neil

Hi nappy,

I am confident we can figure this out. I don't give up very easily. I most certainly will let you know if we do find a solution!

Srodopol
Thank you. Been looking at it trying different things looking at the EMBED code to see if I could use that but not having much luck.

Nappy1001

Neil,

I sure don't think we are alone in what we want this signature field(s) to do for our applications. I have emailed ThirtyTwo about using some VBA to get us what we need or possibly let a formula help us as Mark used with the GS. There may be more than one way to skin this cat. I will be in touch as soon as I find something that can help us.

Hi
Yeah I'm sure there must be a way to input a picture or signature into a cell using an active formula. Wish it was simple. =Insert(picture) here now!!
Neil

Vlady
Thank you so much for that. Learned loads just off that one spreadsheet. I have tried the Index Match for bringing up a picture. I have put the formula in to the Name Manager window and changed the name of the picture but then when trying to put the =name it comes up with invalid reference. Thought I was on a winner as the name I chose came up as I was typing it. Any thoughts??

Nappy1001

Neil,

I realize that the real fun is finding a fix to this problem without having to spend a lot of money - especially if that isn't an option. I still feel we can do so and it sounds like you've gotten close to that already with the info. that Vladimir shared. I will tell you that I did talk with a guy from a company today that offers an Excel plug-in that allows you to use signatures like we want to. The plug-in costs $100. They might also have an app that is a freebie - as he mentioned several options to me. My understanding of this app and how it works is that it can be as simple as a signature that is captured, but it also offers a level of security that allows that signature to stay intact with the data it represents. So, if the data is changed for whatever reason, the signature that was original to the data set is no longer valid. I can appreciate that functionality being offered, but don't know if I need all of that. I simply need a signature or two - which the app also offers.
I am going to try out the evaluation copy of it to see how well it works with our tablet pc's. I will keep you posted about the progress if you would like for me to. I can also give you more info about the company if you are interested in trying it out too.

Just let me know.
-Rookie