eSignature Excel Made Easy

E signature excel

hello friends so today I am back with some other application and Excel is my last total was on store management or you can say in entry management application so this word rate was quite interesting and very helpful and you know managing your spare powder material anything so this time is simple application not as much advanced simple application maybe you want in your daily life it's all about inserting images you can see signatures or any any means like image file you want to put in for example in your form or in adding any other things you according to application so here I admit you know this if you see in my main page so this material acquisition form is like I've made just one simple form basically I want to design a form in which I can directly paste my signatures without you know parenting without arresting my pages so basically I want to keep record so which various abilities this is always verified by this person is for this just example you can use in your own way just justos tell you about how it is possible in Excel so you see one thing is this is all on your application on your requirements so now second thing first of all is you know I hear it's two signatures call boxes one is for oblique and and others verified by who verified this one so basically I will make her two buttons and so I lickin sign okay for example this one too I have to but I'm concerned okay so I will not take time and writing the code so his body very simple and just I am of Equestria so just you know now this code you just understand this one it's like active sheet energy just insert pictures pictures which one this Eddy IDs like variable shows videos taken from data from cell it's basically location location of your image so from where this image loaded it goes from where image copied and pasted and Excel so it is like active sheet dot cells from their studies it's you will change on your own choice I will also change this one cat value okay though I think this a is not used so just cut off this one okay so this is like Lu 10 it's all about just left so where's location left and on the top which location with its like how much must be width of your age and height and some a picture and and with so with you also know this far you can see if you collect swears by using with function and so too do not be at my school application so we will make hair when boxes and when some options so that we can change our let's enter image named equally without going to be be a problem ok so first of all I will right here I will split address in two section one is location not location this right folder folder name where it is meters are placed and name of the file or image image name folder another is like mesh name okay so this one and here when I write here you can say I will write location address so it's like complete you just one time your folder where you place all your images signature images and here you just change your name ok so what I will do now so here I will use come on con concatenate is very good function can use two merged value two single value so I'll merge this folder address okay then I will use this slash so that I can use this name this place then come then this folder name and basically you can add your third option for image extension like jpg PNG so we're not using this extension because my vectors all that I'm jpg so I will make it constant JP dot dot jpg so you don't write with your name this extension just closed it and this one okay so this one now I so all of my signatures are placed in this folder by example two signatures Isis tiny signature copy this address folders and I go here I will press ok so you can see it's like address and a name ok so there are different type of name different and signature of different people different signatures so here I will make one list of people so basically here I have to imply one implied two signatures you can use their names ok so m1 EMP - signature so here I go to data data validation and I put list values or less sources from this one okay so you can just you can just click on EMP one source one and EMP - no way to write again and again so it's the same name okay so now you can see from here when computers forms nature's EMP tutor jpg through some like 18th location later so now you see the second second row and eighteenth column so second row 18 column so this value is noted an ID means it's address okay so now this this will paste in like applicant is C 17 so you could hear here is 17 C is this one so from this if I unmerge this one you see from this C 17 up to like start from Z 17 and top also see 17 so left is 17 this is a cell and top is also this cell and the width end I kept before so from c-17 is startup to e 18 so from this one and this up to here so in this portion of our signature will be pasted here and like we can do this far I had this one so first of all the same thing we do for this this one again here okay so now what I will do I will just change text location this location is like round this to this okay if I I can do all in this box but it will you know erase these lines so I don't want it as a science so it is from H 17 and up to I 18 okay so it's I make it h 17 is 17 it's I 18 18 it's 17 rows nd so you can run your program yes you see you know we can't imply to when I do this imply that I applied to sorry same thing and you want to imply one so here I go change imply one at this signature this one the signature is already I think small there's fires like coming this way you can make it some big one let's make it other like to charity getting so it's worth waiting to give the lady some other sides I have some trouble sharing in basically merging the size in size there's some very wrong shoes so I trade this one and vice again right so now you can see if I'm applicant so imply one news like I say is applicant so its signature here and implied to woods very signature so this all little thing size every height everything you can make it from this thing so did you see it's all about size is different so make it's all I have same size and according to this you can paste your head so if you know that hard implies so you can add a third imply and you can add starting with this this was all about outed pictures and signatures a new form without copying pairs and without having any issues with size so every day few men do it manually then every time you have to make changes in size and other thing so this is all about the tutorial I hope you like it then subscribe and I like my face