Hey guys, welcome back. So in this video, we're going to have another example for the input box. And we're basically going to create an employee database using input boxes. So we're going to input some employee data. So here I have created the macro that would do that. The first step on the macro is that we're going to activate the employee data worksheet.
And then we're actually going to get the last row on the worksheet and we're going to do that using column A's or we're going to get the last row on column A, so as to be able to know where the last employee is and then enter the data for the next employee on the following row. Now we're going to have a variable that is called IB underscore ID and its type is an integer and this variable is going to contain the value for the input box. This is going to ask for the employee ID and with Grade A as an integer because the Idea is going to be a number of course. And please note that although the input box outputs a data type of a string VBA is quite a forgiving language on that. And this IB underscore ID variable that is an integer is not going to cause a problem because VBA will do what is called an implicit data type conversion.
In other programming languages, this could cause a problem, but in VBA, it will not. Now the following step is that we're going to put the ID number in the cell that is following the last row in column A. So as you can see our cells LR plus one, so we're going to the row that is off to the last row and then comma one equals IB underscore ID. And then there is another variable here called IB underscore name that is going to contain the employee's name. When we get the input box that says please enter the employee's name. And then this is going to be put on the same row in column B.
And then there is another variable here called IB underscore hiring date, which is going to contain the employees hiring date that we're going to input into the input box that says please enter the employees hiring date, and this is going to be entered on the same row as well in column C, and then we're going to have a message box asking us if we'd like to add another employee or not. So we're going to have a variable called answer and if the answer is yes VBS then we're going to go to enter another employee which is just a point that we've created here at the beginning, enter another employee so as to go back and get asked about the next employees details. And if the answer is no, then we will just exit the macro using the exits statement. Okay, so let's run the macro here and see how it's gonna go.
So for run that please enter the employees ID. So I'm going to put five and then the employees Name. So I'm going to put john doe and the hiring date. And you can see here, but please enter the employee's hiring date ddmm yyy. So I center it in the international form. So let's say I want to enter the seventh of may 2016.
I'm going to press ok here, would you like to add another employee, I'm gonna click No for now, and examine what's happened here. So you can see here, employee ID five in column A, and then john doe and cell B two here in column B, and then the hiring date has been entered in the international form. So you can see here that the hiring date has been entered in in the international form, and it's not caused any problems for two reasons. First of all, my computer is formatted in the international form. So the date format on my computer is in the international form and all the US form and the second thing is because we've declared the IB day variable as date Now if this variable is not declared as a date, we're gonna have a problem. So this is actually one of the benefits of declaring your variable.
So let's say we're not going to declare this variable, okay, we're just gonna leave it as a variant and try to run the macro again and see what happens. So employee ID to say, I'm going to put six, the name, let's say is going to be john smith, and then the employees hiring date. Let's say I want to put the 10th of may 2016. And let's see what's going to happen here. You can see here it's not been added as the 10th of may spin out it as the fifth of October. The reason for that is that when you enter a date, into an input box, by default, it's going to be understood as the American forum.
However, when we had the variable IBM discord date declared as a date, it actually abided to the date format of my computer. So this is why what do we After the first time when we had the variable ID underscore date declared as a date. So when we had it like that, it didn't cause any problems. But then when we entered it with the IB date variable not declared it caused the problem. So this is one advantage here of declaring your variables