Streamline Your Billing Software in Excel for Pharmaceutical Needs

Billing software in excel for Pharmaceutical

I am welcome to excel tutorial or fantasy management system so let me show you guys how this work if I enter in correct value the system allows three attempts that's two they will do and that's what happened suppose and we enter the correct details in here they will go that should enable all of these buttons okay so we can click on any of this button this button are all cruded there's nothing in here that's just an example if you guys wanna complete that so if I click on doctor so does the doctors page and we can always enter the details of the doctor and see the doctor reference number is Q W white devil and the NHS number and ages and let's just enter name there so his name is Alan Ladd Jones adverse good good this sport center refresh number telephone number hugs email address and let's see patient number I envisioned a diamond up there all they need to do is to add this straight on to the water there we go we can navigate straight on to any other part of the program or add more details on to the world poker okay just to prove to you that if I ever seem to be details on to the workbook I'm just gonna change the name here to let's say the main piece all right let's just I've done five there there we go and let's come straight into patients here as the patient record with about some information for the patient and I'm now going to treat this patient and there we can also add a straight into the wallpaper so let's go straight back to the login system we go straight to the login system the system will officially be of which means you have to log on again but let's have a look at our workbook okay so we must love our force to get get access return to our world yeah that's all we need to look up to here slow dripping dance and let's see the information we've got that is Alan Ladd and those are the details of a date for can re unless C and spreadsheet or sheet number two and sheet number two there we go with all the jumps that without it so with that guys what I'm going to do now is to take you guys straight into Excel development environment and we put one of these put one of these together so let's do that nervous hi and welcome to pharmacies management system to be developed using VBA in Excel spreadsheet application so I'm gonna start by going to file save my project right here as browse okay I'm gonna give you the name the first one is going to be known as they love him they will go save dad and before I save it make sure you change that to Excel macro enabled workbook and click on save there we go now the next thing I'm gonna do is come right here you see the developer if you don't have your developer enable root file select options once this dialog box pops up go to customize ribbon and make sure that developer is checked to make sure this check box is checked click on ok then so you should be able to see this manually earthquake endeavor menu select visual basic now right in here the Select inset I'm gonna set my phone does my phone there you see this little form I'm gonna give the name I'm just gonna call it if our em all let's give it in intervals remember so I'm just gonna call it a love game right that's just the name my name here I'm just gonna call it log n so as you can see a log in is right there now the next time to do for this system is to increase the width let's take this off so that you guys can see it it's gonna change change weight to 1030 and the height angle change Heights to 6 Android okay that's all right then so let's create this add more more spreadsheet Sam Mayer goes straight to my Start button and just click on spreadsheet now have another one these are the one I'm gonna call it I'm gonna call this pathway that I just let's save it in here I will call that doctor I repeat exactly the same thing in there make sure you enable tomorrow trick okay save there we go now go to your menu here and inset the form another form repeat exactly the same thing for this form this farm is will be known as dr. and the caption will be known as dr. height will be 600 and a wish I'm gonna make that's 1030 as well 1030 there we go okay guys now that the doctors workbook is ready I'm gonna add my workbooks I need three more actually so these are the one I'm gonna save that as patient and write in there as enter patient make sure we save it fast enable macros well no macro workbook they come to the design developer to mean when they're inside a form if the a name as patient the caption height is 600 and the width is 1000 tt-they so I'm going to actually create two more of those and I'll be back soon as those are done okay now I now have all of the forms that I need as for the doctor the patient payment and fallacy and he also had a workbook that I required okay so we gonna start with that of the login system so the foster not like to do is as enter a data India so Indian just that's gonna be my title so let's enter a pharmacy management system pharmacy let's say login management system right get rid of that okay so all I just need to do now is to increase the font for that I'm in here let's increase the font they will make that above 48 to be doubled and at the same time you should get it centered the next I want to do is you see this very frame there's been a crab one of those drag it down much I need you have been called a frame blogging system there and without need label and this variable is going to be known as user is the name let's increase the font size to something a little bit too breathable I'm gonna make that maybe 24 alright that's fine hold on the control click and drag so this is going to be known as password now let's enter text box one text box here and another one here select both text box and change the font size to 24 bold as well that is fun now let's add buttons one here too let's make that two and three those are three buttons our intention using this so let's increase the font size for those buttons as well I'm gonna make them 24 as well unchain the first one this one let's change out to see and be loving and the content I need to do logon the next one is going to be canceled and just change that CMB pencil and finally this kind of known as exit gender to CMV exit correct okay so we're going to need more buttons so let me copy this one and just paste it here or maybe let's put them in a frame as well okay so let's add some more buttons here so those buttons will be for my my spreadsheet anyways illustrate this and copy button hold and control click and drag just bring it down a little bit so we need about five of those so then change the names around anyway so this one is going to be known with us those are the names so Davi dr. the bottom will be no Nancy can be doctor okay the next button let's call that C and be patient [Music] on the text content of the patient change a captioned patient followed by payment I change the caption or design want to payment and next we have next we have us going to be promising CMB pharmacy caption CMB Tennessee and finally we have c and b GP so that will just be G appointment okay so we need to actually copy these I'm gonna copy dad's and make a copy here so if I run my system this is how is going to look like but I do need to change the data you have in here and just reposition it properly so let's come in here and run this that much so that is enough for the other one close this will be nuts so I'm just gonna speed up this old design of the interface and get back to you guys okay this is how it all looks now if on let's run it and see that's how is looking not too bad so here let me just because it looks a little bit plain let's clear the panel off sorry a friend I'm just gonna draw a friend from here down there just to make it a little bit pronounced so I get rid of the content about forever and less Bryant and let's see yeah it looks a bit much better now I start work with some proven you see all of these buttons I would like them disabled only when you get the password right then these buttons will be enabled so the first thing we need to do is to double-click on this well form a writing here we want to change the event to form activate or LLC form initialize them so in there let's try that out I'm gonna say C MB dr. got a neighbor whose force there so let's give that a try and see what's going to happen save that let's run our program and see see the doctor form and if doctors button is disabled a right let's repeat the same thing for the others the next one is going to be them just copy all of this CMD that's what the patient now you I guess you get a whole idea and speed up right all of the buttons are taken care of so the other one that I'd like to take care of is going to be the username as meant to be txseries name dot let's say X whatever is in your plate then txt username that set focus and CFC password it initializes claire whatever we'll have in there there okay that is how it looks now so let's come in here go to the phone run you can see we want I expect everything to the disabled okay all right let's take care of classroom and exit we come through thus easy we can just copy this copy everything in here and just call it the die here call fun initialize there we go that's taking care of as easy now let's come into exits double click on the exit the first thing we like to do is declare a variable and we'll call that I exit as an integer so I exit equals message box msgbox and what do I want in there like the user to confirm to exit right confirm if you want to exit and give that VB question map plus VB yes or no comment I'm gonna enter ever see my sister closed above now supposing the end-user selects if I exit equals VB yes then I want the system to unload me and if there with others now let's give that a try come in here run the program try this out you see that ties and let's try this out suppose you have something ended okay you see that so what I'm going to do now is for steam is let's exit out of here now we need to be able to call all of these forms so let's double click on the doctors first and India that form is actual threat to us doctora see if it's gonna work dr. dot let's see show okay that's good it works all right Alice I'm gonna connect ologies I just want to try to talk to one if he talks full so let's run this program go and play there good walks so that's fine so back in here under the comment and one other thing is you can always declare all of these formers and objects so let's assume you say if we come up here and to Dean dr. us doctor there we go so we actually call him dr. dot Neal dot show right because the form itself is an object so let's try that out as well if it works run the program doctor does fun as an object okay I'm gonna exit out and come right in here nope yeah so I'm just going to make it look more professional just and change all the objects critical of the object requires an a level five of those then the next one is going to be as a GP on the score that so the GP does for the GP so instead of doctor here I can just change this one to duck and this one becomes duck so that's fun that's the GPS ooh without GP in here and the next one is gonna be patient I can just call that part yeah is the patient then this one I'm gonna make that payment and that will be paid [Music] should be firm promise II just change this one to pharmacy right they are all ready now let's change it okay that's fine that's fine this won't just be GP GP and this will be Doug changes to Turkish well that's good just see that Janus one okay exits yeah all right okay then walk in here the next one is that so this the name for that is Jose okay Pat's touch you [Music] that show what is do we have without GPS would have just be JP dot show correct all of them are not in place okay now that is all done the Swinton I'd like to do our how coming here you see all of these buttons I'd like to copy this marijuana so let's right click copy and come right inside doctor paste it right inside doctor we plan to redesign the whole doctor frame will be the same four days in the sanctification pharmacy they all have that now let's climb inside here double click on that you see all those lines of codes this one I'm not copy it all but before that okay there are five before that I'm gonna need copy all of this more yep this puppies and everything nice on it stay right there that's one taste taste things up W small dose all of these for this alright oh yeah now barking here I'm gonna copy every single lines of code that I have in here this problem is because the name haven't changed the name so it should be five one two three four five coffee now double click on dr. paster right underneath here they recited a point man GP appointment patient payment pharmacy okay now the difference is this one that is fantasy we need to change fantasy here to log a log or a loved it so let's look for whatever his fantasy here so this one will become log and this is film love that show right day and the text content on this one we need to change that this one to love their so the same thing will have to be repeated for this once this piece on a school bus on a Syrian and this love did the name envelope as well right I should change it to magically India let's see let's go back in here doctor can love others love so we move this thing okay we can do it at least right the next one which is payments you can change this to payment to the drug right logging the text content a ninja gender to log in as well double-click on that and we need to change the payment one to a love-in is to love I love dogs show yeah let's go to the next one and that's the patient we need to do that as well let's change that to love I detest content change love okay double-click on a log that's the log I'm just gonna movies here is supposed to be patient change patient to a love they love and this will be known as log home right in here blog dot show I'm patient we're about this patient there we don't have to do everything that I represent patients now we need this GP does a GP their get rid of that change content [Music] double-click on GP where we'll have that let's change that to a love-in and this becomes a lock come here data comes love God show and GP here we'll have a GP GP today them all together now dr. Chang down to love as well now of the club we need to get rid of the doctor one that means love in here dot she writes okay that's fine now I'm gonna move this here now that'll be dr. Reid abduct okay all that is taken care of now let's go into login and the password so let's take care of the password double click on that right right inside here but before I can do anything let me declare some blue over boom dim attempt let's declare that as integer - I should declare another one Bob the other one maybe I should call that check more checkers check us dead now attempt on chair class let's come inside the log in itself double click on the login' again that fence is going to be a size zero Valley the same thing checkers it was zero as well now let's use a duel [Music] teams at Rennes it's less than an equal to three attempt in this case equals 1/10 plus 1 so which means it's being a bull run three times if you don't get it right so if txt use the name dot txt it was I'm just gonna give that the name and we can just call it pork and txt password that x equals 1 2 3 4 10 steps then what do I want the system to do I want this to Claire what about content we have in there Claire and you to play whatever you have in there the Klan and now I want all of this to become enabled everything in here to become an a.1 focus it can't be that where is it right in and a becomes enable we already have this superior to that and this becomes true okay all of these becomes sure they were good and we said focus and the user named Elvis what do we want the system to do those I want you to call as a call I think is called let's look for the name they'll go in - alarms called initialize this one copy that if you get it all man it calls the initialize and and if well initialize okay yeah let it focus as well because Steven run the loop now yes a loop here so let's say checkers people's checkers plus one now if checkers equals three then unload me and if okay let's see this port is being work for us okay before I even try to let's just in 10 days the lips looks funny do it is this indented and get this one in ten to the swarm okay now let's save and come here now run it and see the first place let me just enter whatever India one attempt to attend so this essentially allowed trade as it does work in how I expect it to work so let's go back in there and enter correct details and does remember one two three if this login details are correct I expected to enable a lot of these buttons there we go so we can always go straight into that is payments and just need to some details in there to make the payment look like how it's supposed to look I'm gonna close that because we need to start with the design of the interface of all these forms so I'm gonna start with start with this does the doctors okay move this aside they're so for these doctors interface I'm gonna meet as follows and if some labels labels let's try that again then we can only tell sports okay we're gonna need about 16 of these so less and times the size of the font fest it's coming here and just so let's go for maybe 24 right okay and maybe I should want put them in yeah let's put up the frame so I'm gonna copy these two just dump it in there so let's before eight agent and good side but we have it on this side and now gonna copy each of prayers must come in there and make this like hold up and drop today so let's increase the size of that there we go okay let's try and finish up with this interface so this one is going to be known as doctorís reference angle the next one is going to be doctors initial and it just matter so I think I'm gonna have to speed this up and get back to you guys okay I've finished designing the the interface for each of the forms okay that's how the doctors look like appointment sync I'm gonna copy these of course patient let's climb in here just drop this down this that's in there and just change it to run for patients most common image in data patient that's funny well the next one is payment and chained at the payment as well [Music] a little beat that's my that's right okay Ralph Emerson two movies and that is [Music] did okay [Music] the fingers wanna have the doctor let's take up the doctor again we take it from there change out the doctor [Music] what this run eatin see make sure is saved [Music] enter the correct Beatles Easter to save time doctor let's see fish payment Pharmacy [Music] okay this exit is now working so in the case of the exit we need to find a way to maybe we should just copy the content we have inside exit yeah as puncture to the exit and copy that oh my god our clipping that's copy all of this mess with the doctor nobody double people doctor first point means to combat at least play some double play best tame it don't click on paste and finally from a CD double click and it's all done I love the exit is taking care of okay now that's the exit is taking care of just coming here you see all of these components we need to give them all the name so like this one has no numbers so I'm gonna call as no name I mean gonna call that txt reference number and I'll repeat the same for all because I intend to use it all for something so that whatever data we enter India is actually stored on a spreadsheet coming here it is a name as well right and then off table time this one in the GFC dose so I'm gonna speed up up and get back to you guys chuckling okay every single single component here now has a name so the next thing I'd like to do is your CD reverse spreadsheet for login I think I'm gonna enter all the details in here so if I come in here enter the details for the doctor and that's gonna be on my spreadsheet one let me show you this is ship number one so sheet number two I can use that for another for the second form and so on so let's create sheet number two but this is once so what if I reference that make would be to sheet 1 so what I'm gonna do now it is you see this very one I'm going to add a button and just run it let's climb in here let's push the button here so drag this down and I'm going to copy one of these buttons and this one we'll call it C and B add add to 2 and this one is going to be our t-shirt or artwork book - lets see oh we can just say I'm power move this one I just say to walk book okay to book the and rearranging or not this is gonna be end table okay if I have any other thing I can just add it below so that is its to walk but you can so now let's double click and to walk book so because what we need is because we need to be able to call the very first book I'm gonna declare a variable DSL called available work as worksheet right so let's declare another and in art as range we're going to need the ranges road and set work equals sheet 1 so the very sheet one that I'm referring to is the one I showed you guys earlier which is right here this very one does the sheet one I'm referring to now okay so sets Ogden it was walk sheet dot let's take it from the range the rain that I'm gonna specify will be 65,000 let's make that day from rule a sixty five thousand three hundred and fifty six I just place that dot end and let's ask it to blow up up close that and make sure is offset by 1 comma 0 there we go now I'm gonna add my very first component so that's going to be you say odd add new dot offset 0 0 ok that's a girl first one and that value so what is my value I'm gonna say I think is txt let's see was the name of that the garlic is TXE dub for reference number okay little more poop tht inductor reference number you got Thanks so that's the very first one so what I'll do is just copy this around I have 16 in total I'm just changing understand the names so this one is going to be one there's two and that is three so all I just need to do now is to get the names of each component this is number two copy that as doctors NHS number go right inside the code and change that then followed by the next one as first name I think is followed by seven and good let's go in there again and Sonia I guess you guys get the whole idea I'm now gonna speed that up and get back to you okay guys the first lot of the code I will start value what about with entered and the system is taking care of so what I'm gonna do now is is double click on that run the program and see now the reason most times I'm gonna enter the right value instead of playing around and go to doctor right in there as the doctors so let's enter some data in the adductors reference number dr NHS doctors number name who is the doctor let's see yeah why not Paul Onan Medical Center let's go for cotton carlton hill and address of the center 45 let's wrote for sport Medical Center where friends name or reference number telephone number sector telephone number fax number email address the app and GML patient NHS number the m12 a number GP reference and patients whatever the although so I will need to now do is just add that straight on to the spreadsheets and let's see if I'll come in here add and does it to each workbook there were those well let me see my workbook here as a workbook so first and first maybe I should times itself and get our book so notice everything in here so let's come in here ok right here guys you see us do that information on the workbook [Music] we'll have a good look at it so let's add more information and you guys see that think I may have left patient ID out all right so let's talk more information sit back in here doctors reference and it just refers name let's call that Tony ID right add to okay so I can even add it when the times are like but I have to exit first before we can view it yes that's it so let's plan into the spreadsheet itself then you see a song yeah we all do look at that see that's how you add all the information collected straight onto your spreadsheets okay let's repeat exactly the same thing for patient form and in here and save - freight and to a spreadsheet workbook - so let's see what we've done so far first of all I'm gonna have to exit from here transit yeah and let's see spreadsheets okay let's pull out these so now you can see spreadsheet number two does number two there and right there those are the information that I've just added a spreadsheet number two and just before I call it the end of this tutorial let me show you guys one thing I love this spreadsheet that I created you don't really need it you only need one spreadsheet so that you can store information and one spreadsheet all there need to do is just create add more spreadsheets okay so with that guys imma call it the end of this very very advanced tutorial I suppose you guys enjoy it so I'm gonna say you all have a nice day now and bye for now bye [Music]