How to Create Payroll Management Systems in Excel using VBA

welcome to excel vba payroll management system to start with if you don't have your developer men out there or advise you to roll file select options and get is there a dialog box come to customize ribbon and right here is your developer man right there is not checked make sure you check it and click on OK and you end up with this very menu click on that very many select visual basic if you don't have this waveform go to instead click on use your phone then you can define the size of your phone this isn't the size of my form right there I already have a break I don't really need the country but just to show you guys what I do we might as well use the phone 3 okay in from 3 the first thing I want to do is to define the length or the height of my form right here now come here and define the width there so the width is 100 10 or 20 Y the height is 680 right there the next thing I need is a neat couple of components slightly tuned box label I need some labour Ryder now be changing the color of the other level it's copied easier prepare that is that a name that's my label right day ok whatever content I have inside our label let's come to the caption delete that and enter as follows a arrow management systems okay now change the color think maybe I should go for white color right there well something bright and increase the font size to approximately less before maybe 68 there okay maybe a little bit more you can go for 77272 okay 72 and I can even increase it more if I choose to okay that's my that's my form right there or that's my label so when you just copy another one bring it down to cover some parts they bring it down I just want you guys to see how I'm going to develop everything so it detects content in here I will delete all of that because I don't need it first need it as a pattern really and Brad drag it all the way down that is that so the next thing I'm going to need now is I'll need as follows let's go for and a couple of frames here one meter here I'm gonna need some more so maybe a shoe speed this orderly so that this doesn't take too long but then I need some labels here label and textbox okay right up here take this down here need text box here couple of buttons here and so I'll just speed up the development and get back to you guys okay guys this is how the whole system is looking right now so next Amy said I'm come here to the property have all the property here so what I'm doing is having other needies from - so let me get rid of girls we'll go does it come okay that's a from true gun all right so the next thing is I think I need to complete let me just complete this interface right here select it all and sort of like in crazy chain the font size delete whatever we have in there and change the font size to something a little bit larger let's say to make that maybe twelve and bold day okay so let's enter numbers do you guys know what is supposed to be a calculator for the that's very payroll management system do need a couple it onboard as well for the clients will be using this system it's neither so I'm just going to speed this up and get back to you guys and we'll take it from wherever I started so let's speed this topic okay guys this hard system is looking right now so maybe let's just start with the coding anyway so I'll double click on that bring this down and declare option action explicit ok that's fine and the fourth thing is LS declare first number let's make that double to class second number as well those are the variables to be used by the calculator that double as well and we also need to declare one more for the results less a result first double dead then we all do they need one to hold the strings I'm going to call that a prey to the separators with an S as mean that us-trained then so those are all in place for the calculator and let's come in here make that double click please and sometime click on these very first button right there which happens to be more than one but maybe we should give it a name let's give it a name so that's it looks a bit professional coming here to Deb put in a name so that we see md7 let's just call a 7 and I'll just repeat the same thing for the rest this one will be c md 8 cm d 9 and so on then speed that up ok they all have a name now I'm just show it to you guys you can see CMD 7 and so on up to CMD multiplication so if I double click on CMD 7 now I can just enter Oh left have something less enter 0 in here come back to the property of the text box which is known as THC display come right down here enter 0 in there and let's align it right and change the font size font size this chain that swell to about maybe 10 yeah why not let us form okay now double click on CMD 7 + Enter if txt display display the text equals 0 then C can be displayed of text equals 7 they just copy and paste that is feeling lazy change out to 7 come right down here else display TXE display the text it would see txt display and 7 show you now come down here and just enter and F alright that's that taking care of I'm just going to copy this let's copy but let me just run what I've done so far so that you guys see it anytime I click on 7 see that ok it's nothing happening not 9 and so on nothing happens there it close that scroll double-click on it pace what I've copied in there change it cuts content to 8 that is 8 8 so I will speak that up instead of self hanging around a modest or just speed it up then come back to you guys that is 9 9 ok all of the numbers has been taken care of as you can see you see which are all similar that's four zero one two three four six seven eight nine and five seems to be right up here that it if I run the program now we can just play around with your calculator but we cannot carry out any calculations or anything it seriously need to enter some codes for the plus sign of the vision and so on so let's take care off declare button force to click on that I'm just right be how to clear writing and doesn't copy that and that is it that's great taking care of and let's come back me and double click on the plus sign okay okay the next thing is for us to take care of the boss let me just check that okay now you guys can see that so I'm just going to say the variable num 1 equals txt display the text so what that means is whatever value I enter inside e this place should be stored in right in here okay so the next thing is let's get rid of whatever is in there now and then the operator let's see what the value is called is called operators so just pop it up and bring it right down so operator in this case equals the plus sign right there so it does just all for the plus sign operator so let's take care of the next one that it is this that's for a minus 2 Brenda Oh Carol - changes to - and maybe I should just get rid of this has Carol to get rid of it yeah that's fine okay now double-click on thing that is division so change that a division there now one more the multiplication multiplication change to multiplication so all of my operators are in place now I would have loved to enter the decimal points angry about there's not enough room okay let's go ahead anyway if you want to know how to create a full calculator you should see that on my excel may be a program online okay so the next thing we need to do now is take care of the plus so with applause we just need to say second number second number or txt display dot txt and use an e statement if operator know that's there the operator in this operator equals the plus sign then I believe is result a course first number plus second number there and txt display that x equals result okay that's the first part taken care off so we can now say else if else if operator if operator is totally different from the plus one okay if it's minus then just become minus as well and else if okay just end that okay if is division I'm sorry then if is now set deviation then this one is division this multiplication it is multiplication so the calculator is all taken care of let's run the program and see okay this x today's April 30 arrived so let's check out what happen the second number let's see the spelling of second number all right of the second chamber to number plus one okay so let's run it again this Plus this that's correct times three okay Maya six divided by eight okay that's correct so the calculator is now working as expected so let's take care of addition pair reference and reset and so on let's take at this one soon let's do the easy one first easy one here is this double click on that and just enter them unload me unload yeah that's taken care of so the exit is taking care of now we need to declare more variables come right down here and declare as follows the following variables yeah that's for marked a management system so now let's take care of our payment right in here which we entered as follows those are the lines of codes for the odd payments so if you look at it from up here let's take it down as you can see it does for our payment it should be that the game does it so the next one let's come here and check that out so the next one is let's take care of the reset button so right up here enter the code for the reset button does that lines of code for the reset buttons okay so let's come down go back in there okay since we've taken care of but we said let's take care off for a reference out like this is then to generate some reference number for me so now BD reference number let's get rid of the dates I like the dates to generate itself automatically this is the reference number maybe I should just change this one to one thousand if I run my program I can always generate my reference number automatically right again as it takes it so double-click on the form itself and come to change things or the metal changer to initialize and let's bring them up okay I want you guys to see that right here use the phone initialize enter the following so that my date will be generated if I run it to see the data to multiple it out the date the second month of January 2016 and generate that tells it I get our walk so the next thing is let's take care of this very one here my hair doesn't add item double click on part item and just enter the following lines of codes day so what we happen is these lines of code we actually enter whatever data onto the spreadsheet itself so let's try out this system now run the program enter name there so let's call that our mark Tom okay left on this one an address is say Julian would reference number we go India to magically employers name employers maybe they're just probably to this m- SMG okay now employee name location began among what discuss all right okay now the inner-city wages that says does is in a city wages and basic salary of about that and all the time is it down 12 hours overtime okay now period the period is period 12 tax code as the fast food is d and i number i'll say m e+ is ni number that's good let's mean that d here is over six and that is all that is report POSCO right here is f whatever i'm gender gosh me male there so all just need to do now is to click on the add payment and that is it okay or wages so and right here reference got the P reference and you can research if you want you can just use these odd so that means we've added all of this information straight on to the spreadsheets so let's see the spreadsheet right here I'm right underneath you here you can see Mac term right there and all of the information that we've added for him okay let's write again to run the system again using another data completely different data okay you can if you guys want you can actually change pirate a lot of changes like here this can be combo box all of this can be combo box really but I've actually finished my design that's alright so let's run run it again let's say the name II said the name happens to be then we more address Kingsland Road and that would be SW whatever yes that's a telling so as we female and enter here reference for her a name Elam and employ as Helen day employer she's walking for help from none limited all right in a city that's what she get on basic salary their overtime she loves to walk and that's all there is to it so let's just enter the task code say G G ever their tops number and I number and I okay okay and I code so let's click on nod debug that to the table and see what happened okay that should be an integer not a G so let's go back in there alright this is a way there should be an integer okay so let's run it again oh another way out is you can just leave that a string to it we accept anything let's change it to instead of integer we can always change that too I'm just going to change it to the frame drop combat and just run the program again okay let's say this time around the name happens to be look dipstick okay address let's make that good good time good time good okay now need to enter employers name so they say it works or join you means it and its name look just a then the next thing we need to do now is enter in a city which and basic pair is well paid overtime he doesn't need it alright right here the period is generally showed out the one and here is tax code that says TC has tax code ten I number and I'm and followed by and our code and our code okay there so need to scope there sw3 gender male click on add payment day the reference let's see if we can get this yet there we can get it now we have map Tom India so let's add to reference we file coming here I'm sorry add to item right here these were the one if I click on that there and you guys see that okay I say Adnan and say see how that works okay so we don't talk just leave you guys with this very very beautiful payroll management system but as you can see the calculator works as well if you have any need for the codes you can just get in touch with me so we doesn't say have a nice day bye for now

Channel: DJ Oamen

Views: 180,969

Keywords: Payroll Management Systems in Excel using VBA, Payroll Management Systems in Excel, Excel using VBA with IF Statement., Systems in Excel using VBA

Id: TjMTfSVOWyg

Length: 26min 23sec (1583 seconds)

Published: Sat Jan 02 2016