Download "Como crear una #BASE DE #DATOS en #EXCEL con #FORMULARIO y botones personalizados SIN #PROGRAMACION"
%3Aformat(webp)%2Fi.ytimg.com%252Fvi%252FoUsVRWqMtEs%252Fmaxresdefault.jpg&w=1139&q=75)
Please wait. We're preparing links for easy ad-free video watching and downloading.
Similar videos from our catalog
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252F31oAp7sEvKA%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi%252F4xxHnkh_Ias%252Fmaxresdefault.jpg&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi%252FF8871UifgD8%252Fmaxresdefault.jpg&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252FZBxPN7dKjiM%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252FdjYVntVFAQo%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252Fi36MPqZ8Vpw%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252FibhsV60RUH8%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi%252Fok9U0mNitUA%252Fmaxresdefault.jpg&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252FxIx-gSbSUMk%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252Fzk_X_7RB-EQ%252Fmaxresdefault.webp&w=1139&q=75)
Video tags
Subtitles
Russian
00:00:01
welcome to one more video on Tuesday, you already00:00:03
know Template Tuesday, today we have00:00:06
a downloadable template to create a00:00:09
database, our own00:00:11
database in Excel using a00:00:12
data entry form, in this00:00:15
case we are going to do it. to act as people, no,00:00:18
but those people can be clients, they00:00:21
can be students, they can be00:00:23
staff, they can be 12 players from a00:00:25
soccer team, what do I know? It can be00:00:28
applied to any type of00:00:30
data entry. What we are going to learn here is how to00:00:32
enter data. data and use00:00:33
personalized buttons with icons and00:00:38
validation so that the data we00:00:39
enter is correct and is00:00:41
stored in a database of00:00:43
our spreadsheet, as I always00:00:46
say, you know, I really appreciate your00:00:48
thumb up and the registration in the00:00:52
subscription page on our page on00:00:54
our our channel so you can00:00:57
receive notifications activate the00:00:59
bell subscribe and00:01:02
be aware of all the00:01:04
notifications every time we00:01:06
publish a video you already know that this00:01:08
template is in the description so you can00:01:11
download it adapt it to your00:01:13
requirements modify it as00:01:15
you like and you can use it00:01:17
so without further ado we start00:01:20
i00:01:22
[Music]00:01:25
well this is the template in the00:01:27
data entry template00:01:28
here what we are dealing with is for example00:01:30
look for example the clear button what it00:01:32
does is precisely clean the00:01:34
form and we can enter00:01:37
data in this way in validated cells,00:01:40
not the name, I don't know what it is00:01:44
[Music]00:01:46
sec we can only choose00:01:49
the age from a drop-down list, we can still00:01:52
insert the phone in this way00:01:58
like this and it validates us so that the format00:02:02
appears this way, not the address,00:02:04
also00:02:06
the one that is not the city, for example, we put the00:02:09
marital status, we also choose from00:02:12
a list the one that is not divorced00:02:13
and what we are going to do here right now00:02:16
is press the save button and Once it is00:02:19
saved, this information will appear00:02:21
that says that the data was saved00:02:23
successfully, I say accept and that's it, and to00:02:27
create a new one I simply say clean00:02:29
without cleaning the data and we see that here in the00:02:32
database down here in the other00:02:34
database sheet data, the00:02:37
record is being created, notice that00:02:39
Maria José Cuenca Divorced has just entered this moment00:02:42
and if we want to delete00:02:44
this last record entered, then we00:02:46
simply click on the00:02:48
delete button and it tells us that00:02:50
the last record has been successfully deleted,00:02:52
ready to accept, let's go Let's see and it has been00:02:55
eliminated and well we will have it ready and00:02:58
adapted to any type of data that00:03:01
is what we are going to build friends well00:03:03
we are going to create a new a new00:03:06
document00:03:08
in such a way that we adapt the00:03:12
document as you already saw it has two sheets00:03:13
the first sheet is called00:03:16
data entry, I usually always put00:03:20
the sheets without spaces and delimited00:03:24
by capital letters and here it will be called00:03:26
database, these are the two sheets00:03:29
that we are going to use,00:03:31
so here the first thing we are going to00:03:35
do is create the format,00:03:36
first what I did was remove the00:03:38
division lines, not in view, I'm going to00:03:41
click on lines00:03:43
grid lines so they can be deleted, look00:03:46
this way everything is deleted and I'm going to00:03:48
insert, we're going to insert a shape, the00:03:53
shape that you used is this hence it is00:03:55
called a rectangle which is one that has00:03:57
rounded corners and to make it00:03:59
exactly the same measurements we are going to00:04:02
go to the other document that goes from00:04:05
column h to column and there they go from h00:04:10
to column well here we have expanded00:04:12
a little00:04:14
well delivery occupies us 1 2 3 4 5 600:04:17
and a half columns that is what occupies us00:04:20
6 and a half columns00:04:22
we are going to see from the column to00:04:26
one two three four five six00:04:28
and a half columns more or less up to here around now00:04:32
and the shape of the filling because I am going to give it00:04:35
this light blue as well as the edges00:04:38
in this way and the edge here I am not00:04:41
going to make it so pronounced since from00:04:44
the tomato dot, notice we can00:04:46
modify the edges, we are not going to go first,00:04:49
we are going to give it like this since we Let it be00:04:51
quite rounded like this, we are going to modify the00:04:53
text with right click edit text and00:04:55
we are going to put, for example, data entry00:05:03
and we are going to put it centered both at the top,00:05:06
bottom and left and right and we are going to00:05:09
make it bold and with a larger flap00:05:12
ready we have income of data now the00:05:15
next thing is to insert a shape the same00:05:19
shape with rounded edges is00:05:22
here and we are going to say that it is going to go from00:05:25
here00:05:26
to here possibly more or less00:05:30
there this one had another fill color that00:05:33
would be this one00:05:36
this one here yes and the edges too and00:05:40
it had a shadow effect, not a00:05:43
shadow effect, which was this one here or not, yes, I'm not00:05:46
wrong, this one didn't have, didn't have or does00:05:48
n't have no fill, shape fill is00:05:52
without fill ok, and we're also going to put a color on the border.00:05:58
Now there, more or less, this, if the00:06:02
edges have to be a little00:06:03
smaller, more or less there, and that's it, and00:06:08
here we're going to put no, let's00:06:11
see the ID name, sex and age, ID00:06:15
name, sex and age, they were over here, let's00:06:19
move it a little. I'm going to insert one, I'm going to00:06:21
insert one exactly there00:06:25
and we're going to lengthen it a little more or00:06:28
less over there more or less over here and00:06:31
then there we start00:06:36
ID card00:06:40
a man00:06:43
sex00:06:46
but this I'm not going to align you to the00:06:49
right like00:06:50
this and This is where we are going to00:06:53
insert the data, I am simply going to00:06:55
give a different color to the background, I00:06:58
am not going to say that the filling is, I don't know,00:07:00
faint of this color,00:07:02
the name will occupy two two cells, the sex00:07:05
as well and the age as well, and then00:07:09
we have to see. telephone address city00:07:12
and marital status telephone address city00:07:15
and marital status00:07:18
telephone excuse me for the accents I00:07:21
am not using the English keyboard the accents do not00:07:22
appear telephone address00:07:27
a custom address00:07:30
city00:07:33
and marital status ok and we are also going to00:07:37
align it to the right00:07:39
of this form then telephone00:07:41
will also be like this the address will also have 2200:07:45
cells the city will only have one and the00:07:47
marital status will have only one ready we already have this00:07:51
form of the form now simply00:07:54
what we are missing is here below the00:07:57
buttons that will also be other forms00:07:59
not00:08:00
what forms are the same this one here that00:08:03
would be for the button again00:08:07
I'm going to copy the control c00:08:12
there is a feature that has that00:08:17
windows has sequence that I am00:08:18
using windows d00:08:23
notice how it is copying me no control00:08:27
windows on mac and it gives me in this way the00:08:30
users of windows, I don't know if this is normal,00:08:32
those who use Windows a lot, leave me00:08:35
in the comments, this one,00:08:39
leave me the comments, those who use00:08:41
Windows a lot in this way of copying, no,00:08:43
because it appears like this, I don't know if it's00:08:45
normal, because you didn't use Windows much, but00:08:47
well, we already have them. three buttons now00:08:50
we are going to first insert text into the00:08:52
buttons and right click we are going to say00:08:55
edit text and I am going to put this is the00:08:57
clear button yes00:09:02
and I am going to align it center down00:09:06
this button is from the d00:09:10
delete00:09:13
last this is called delete last I'm going00:09:16
to make it a little bigger and I'm00:09:18
also going to align it down and to the center00:09:21
and the one here was called00:09:24
the day it was called save00:09:28
this is the save button center and00:09:31
down because in this way because00:09:33
here I'm going to put the icons so what am I00:09:35
going to do, I'm going to insert00:09:38
and here I'm going to say icons, look,00:09:41
and it's going to open this00:09:43
icon window where we can search for icons of00:09:46
all types, not all types, the ones that00:09:49
we can use, for example, here I00:09:51
want the document like this called00:09:57
is this one here so I'm going to select I'll00:10:00
select look how I selected the00:10:03
icon this way now be careful with this00:10:07
once the buoy icon is pressed00:10:09
press the shift key and I'm00:10:11
also going to press the button and then once00:10:13
the two in this00:10:14
way I'm going to right click and I'm going to00:10:16
group them like this so that they become00:10:18
a single element if you see like this00:10:21
here I'm going to do the same with the00:10:24
delete button we're going to insert icon00:10:27
and I'm going to say delete like this It's going to call00:10:31
my icon, it's not this one here, I say00:10:33
insert, I place it more or less here00:10:39
since in the same way I have by pressing00:10:42
the shift key, I keep right click here00:10:44
and I say group00:10:47
and finally the save one in the same00:10:50
way, insert icon and in icon I'm going to00:10:54
look for00:10:55
art it wasn't called00:10:58
the icon it was called disk I think if disk00:11:03
is the one here I say select and I00:11:07
place it over here and only the resizing00:11:10
we take to the part of creating00:11:13
the macros I select crushed shift I00:11:16
select right click group and ready00:11:20
I already have the perfect initial format00:11:22
now what are we going to do we are going to00:11:24
validate these cells so that they take a00:11:27
suitable format and no value can be entered00:11:29
we are going to start with sex00:11:31
we go to sex and we are going to go to00:11:34
data and in data we are going to choose00:11:37
data validation and here we are going to say00:11:41
that it is a list and here we are going to00:11:43
allow if male and separated by00:11:47
semicolon female eye in my case it is00:11:51
semicolon but it depends on the00:11:52
configuration of each of your computers. In00:11:54
your Excel there are times when that00:11:57
is the comma, no, but in my case it is a semicolon, in00:12:01
this way00:12:04
I have already validated, look at the00:12:09
path, no city, no marital status, if00:12:12
we are also going to validate in the same00:12:14
way, we go to data and we let's go to00:12:17
data validation in00:12:19
data validation we choose list and here we are going to00:12:22
put the marital status not single00:12:26
semicolon married semicolon widowed00:12:31
divorced00:12:37
de facto union I hope that is the name of the00:12:39
new marital status single married video00:12:42
divorced de facto union to accept00:12:44
ready00:12:45
now well look we already have00:12:48
the options here we are simply going to00:12:52
validate what it is there for have00:12:54
a validation and not be able to enter data00:12:56
that is not for example a text no a00:12:59
text is not a valid ID00:13:00
simply in data we are going to00:13:03
validate of data in00:13:05
data validation we are going to say that it is an00:13:07
integer but greater than or equal to or greater00:13:12
than rather or greater than having the ID00:13:15
has 10 digits but in the 10 digits00:13:19
in most cases there is a zero00:13:21
in front so automatically as00:13:24
is a leading zero becomes00:13:25
nine digits so we are going to put00:13:27
here a minimum nine digit number00:13:29
which would be one two three four five six00:13:32
seven eight eight numbers nine that the00:13:35
next number after this would be00:13:37
a number the first number of nine00:13:39
digits and I simply say accept00:13:43
in this way I already have here validated00:13:45
to be able to enter an ID number00:13:47
but I also need to give it a format00:13:49
eye right click cell format and in00:13:55
cell format I am going to tell it to be00:13:58
personalized and here in general I go to00:14:01
put00:14:03
seven eight nine ten ten numbers zeros00:14:05
so that the zero that is eliminated at the00:14:08
beginning when you type a zero an00:14:09
ID number you will notice that Excel00:14:12
eliminates the first number zero because00:14:14
because it considers it an integer00:14:15
because they are for 1 - in addition then it00:14:18
considers it as an integer and one00:14:19
you know, you know that a zero on the00:14:20
left has no value so that's why it00:14:22
eliminates it with this, what00:14:24
we do is that Excel does not eliminate that zero,00:14:26
I say accept example,00:14:30
enter a number and notice, don't let me know.00:14:32
It eliminated the number zero and keeps the00:14:34
number as it is. Now we are going to validate the00:14:37
phone number in the same00:14:40
way we are going to validate the data and00:14:42
here we are going to put it as an00:14:45
integer numerical value greater than the00:14:49
phone numbers so generally they are 9 digits00:14:51
onwards 9 and 10 digits so in00:14:53
this case we are going to put 1 2 3 4 5 6 7 and00:14:56
8 if greater than this00:15:00
and we say accept and the format that we00:15:02
are going to right click on00:15:06
cell format is going to be the next one in00:15:08
personalized I will simply write00:15:10
this way no 0 000:15:15
hyphen 1 2 3 4 5 6 7 8 and 9 9 digits00:15:24
we are not too many there are 33 editions 700:15:28
8 and 9 there we are00:15:30
7 numbers 0 is the hyphen and the two00:15:32
numbers are ahead of us so that so00:15:34
that in case we enter a00:15:36
phone number by entering the area code00:15:37
for example 0 7 and I say 22 45 6 78 I was00:15:44
missing one I was not missing a number in the00:15:49
format right click cell format00:15:53
10 more00:15:55
and also here in the data validation00:16:01
there we are accept and delete a number00:16:05
then for example 0 72 45 6 78 press00:16:10
enter and notice how it gives me the format no00:16:13
yes this way let's see what happened here00:16:16
here we are with a number and we continue00:16:19
with 10 more00:16:21
there there yes there we are with the format00:16:23
well00:16:25
in this way so look we00:16:27
have already validated these data here00:16:29
city of age age only that it is a00:16:31
numerical data data validation00:16:33
we say integer greater than or greater than00:16:37
or equal to for example I don't know let's go Let's00:16:39
assume that we are entering data from00:16:40
people of legal age, nothing more than00:16:42
or equal to 18, point, the00:16:45
problem is over, so here, yes, that's fine.00:16:47
15, well, it won't let me enter 21,00:16:50
well, it already leaves me and these data00:16:53
are simply text data. no00:16:57
bolivar and san martín and city can be00:17:01
fifth ready I already have my data now00:17:05
what are we going to do let's00:17:06
create the database here for which we are going00:17:10
to write this data from here00:17:12
ID name sex and age no00:17:16
ID name sex age we also had00:17:23
telephone address city and marital status00:17:26
telephone address city and marital status00:17:34
lasts name sex age telephone00:17:36
address city and marital status correct00:17:38
now what are we going to do here I'm going to00:17:40
select this and I'm going to create a00:17:44
table format for it so what do I do I'm leaving to00:17:46
insert and I say table ok00:17:50
everything is selected and I'm going to say that the table has00:17:52
headers and I say accept now in this00:17:57
way I'm going to give table ownership to00:17:59
this data here so that00:18:02
automatically well00:18:05
let me if we're going to assume that I have00:18:08
data from here, name, sex or whatever,00:18:12
I'm going to put data only so that I00:18:15
can do the demonstration, a phone number,00:18:16
city address and00:18:20
marital status, whatever it is, it doesn't matter to be able to00:18:22
build the macro, look and measured00:18:25
too much, I'm going to delete this.00:18:27
There we are ready well once I00:18:31
have this data I have the format and00:18:34
I go to this table here I have to00:18:37
enter this data based on what I00:18:40
enter each time I put the00:18:42
save button yes each time I press00:18:44
the save button is going to save that00:18:45
data and since we are not going to use00:18:48
visual basic code we are going to try to00:18:50
do it in the easiest way possible the00:18:52
only thing we have to do is record the00:18:55
macro we are going to record the macro first of00:18:57
saving that is For this data to pass00:19:00
here and it is a very simple thing, we do not have to00:19:04
simply use the00:19:05
programmer button, you know how to open the00:19:08
programmer button, it is in the video00:19:09
in several previous videos where you can00:19:11
see how the programmer button is added,00:19:13
we are going to choose to record. macro00:19:16
now and record macro what is going to00:19:19
allow us is first to give00:19:21
this macro a name in this case as I was going to00:19:23
try to record the data I am going to put00:19:25
record I say to accept00:19:29
ready my macro is being recorded now00:19:32
well as we know that This is recording,00:19:34
I have already repeated it countless00:19:36
times because because the button here says00:19:38
stop recording, this means that00:19:41
the macro is being recorded and everything00:19:44
I do will be recorded in that macro, that is,00:19:47
if I click, if I delete something,00:19:49
something was added. etc. will be recorded00:19:52
in that frame so you have to be00:19:53
very careful, you00:19:54
have to identify the steps that we are going to00:19:56
take within the recording to avoid00:19:58
making mistakes. The first step that I00:20:00
am going to take here is to first00:20:03
create the space here in the database00:20:06
to be able to insert the data there and do00:20:09
not overwrite the last00:20:12
record entered, as in this case, if00:20:14
I simply copy the data here,00:20:17
this will be overwritten and I do not00:20:19
want it, I want the00:20:21
list of records to be created, it is not True, the00:20:24
database that I am going to create is here,00:20:26
first with a normal click,00:20:29
first I give it a normal click and after00:20:32
the normal click I am going to select00:20:34
the entire row by clicking here.00:20:36
Notice that there is a little arrow pointing00:20:38
to the left if you see00:20:40
We click there and what it will do00:20:42
is mark the entire row now once00:20:45
here right click and say insert00:20:49
and in insert I will say insert rows00:20:52
of the table but where below or above00:20:54
I will say up00:20:57
so that this goes down If this data that00:21:00
was here above and below because it was00:21:02
inserted above this data,00:21:05
the row that is this one was inserted, this for what, so that I00:21:07
can enter the records00:21:11
here ready, then once I have00:21:14
entered the line, the row, look at00:21:19
everything, inserted. I am doing this within the00:21:20
recording once I have it inserted00:21:23
because I am going to proceed to copy one by one00:21:25
as simple and as simple as that, click here00:21:29
right click and copy, I apologize for using00:21:31
the mouse and not control, it is concluded because00:21:33
since I am using Windows For Mac,00:21:35
the keyboard is a little different00:21:37
and it is difficult for me not to copy anything00:21:40
else. No first step. I always do a00:21:42
normal click, not a normal click, and then00:21:45
right click and copy from Boyacá. I also00:21:48
go here with a normal click,00:21:51
right click, and I say paste special. and in00:21:53
paste special I want you to copy the00:21:55
formats00:21:57
and values I choose formats and values00:22:00
said to accept so that the zero is not deleted00:22:03
from here and then we go to name00:22:05
name I select normal click00:22:08
right click copy return here00:22:12
normal click right click on this case00:22:14
special paste as it does not have any format the00:22:16
name I only put values ready let's go to00:22:19
sex00:22:20
normal click right click copy00:22:24
return here normal click right click00:22:27
special paste also did not have a00:22:30
specific format this I say only values let's go00:22:33
to age age normal click right click00:22:38
copy I come back here normal click00:22:42
right click paste special also only00:22:45
values because the phone did not have a00:22:47
specific format the phone did00:22:49
have a format so I click00:22:51
normal right click copy I00:22:55
go here normal click right click00:22:57
paste special and I'm going to paste formats and00:23:01
values accept00:23:03
let's double click it to00:23:05
adapt ready look at address let's go to00:23:08
the address normal click right click and00:23:12
I say copy let's go to database00:23:15
vick normal right click pasted special00:23:18
only values because it didn't have00:23:20
any format either now we only have00:23:21
city and state left civil ready city00:23:24
normal click right click we copy normal00:23:28
click right click pasted special only00:23:31
values accept and finally civil status00:23:35
in the same way normal click00:23:37
right click copy00:23:39
and we go here it is normal right click00:23:41
pasted special only values ready we have00:23:47
copied I go back here and here So00:23:50
that this copying contour is removed, I00:23:53
click escape and come back here and I have already00:23:57
copied the data. Now I can stop00:23:59
the recording, I say stop recording and00:24:02
that's it, my macro has been created and once I00:24:05
have created my macro, the00:24:07
only thing that What I do is simply and it has00:24:09
stopped the recording I have already stopped the00:24:12
recording00:24:13
I am going to assign it to the save button with00:24:15
right click I say assign macro I am going to00:24:19
assign the macro that I just created00:24:21
assign macro and here is the macro look it00:24:25
is called record well this is data From00:24:27
another one on the other sheet, no, but it's called00:24:29
record. I say accept and that's it.00:24:37
Here's the new macro. Let's see.00:24:39
Right now, I have these two pieces of information.00:24:42
I'm going to execute the macro as executed00:24:44
by clicking here. Just00:24:45
click here. Look at that blinking that you00:24:49
see now. We are not going to delete, don't00:24:50
worry, look, the data has already been copied,00:24:52
look, and we already have two records. If I00:24:55
change, I'm going to put red here. I'm not00:24:59
going to change everything. I'm not saying marital status,00:25:01
married,00:25:03
and I'm saying that he lives in Guayaquil and that he's00:25:06
30 years old. I'm going. Let's record this00:25:11
flicker, don't worry,00:25:12
we're going to remove it from the code, look at Ana Rojas,00:25:14
female, and she created the record. That's00:25:18
the important thing that we're00:25:20
correctly generating the record, and she's00:25:23
doing it well, perfect, we have our00:25:25
first mark,00:25:27
next, we're going to eliminate it. to delete00:25:30
this data from here very simple we00:25:33
will add it to a macro here in the00:25:36
clear button simply in the00:25:38
programmer button we are going to say record00:25:40
macro and here we are going to put delete yes00:25:44
because it is going to delete the data one does not00:25:47
clean clean for Don't get confused00:25:49
because I think they delete or clean00:25:52
data and clean data to accept ready00:25:56
the macro is being recorded notice that it00:25:59
says stop then what do I do very00:26:01
simple I simply place myself here in the00:26:04
good in this case in the first in the00:26:05
first the card does not I click on them normally00:26:08
and delete here delete here delete and00:26:12
I'm going to delete one by one with a click and00:26:14
with the delete button the data ready00:26:17
and I'm left here nothing more00:26:20
absolutely nothing more just that I have00:26:23
the recording I mean having a recording and00:26:25
Here is my macro to delete or00:26:27
clean form, rather right click00:26:31
assign macro because we have to assign00:26:34
he killed it to the button and my macro was00:26:36
called clean data, this one here I say00:26:39
accept00:26:41
and that's it, you will see how00:26:48
josé sánchez sex male age 3300:26:54
phone 0700:26:59
enter address whatever city00:27:04
to solbes and marital status let's put00:27:07
view ok I'm going to save this data00:27:11
save00:27:12
yes it's00:27:14
already been saved let's see here it is00:27:18
josé sánchez it's saved and let's clean it00:27:23
and it's clean perfect we're fine00:27:27
until there The only thing we are missing is the00:27:28
delete the last button. What this00:27:32
means is that we are simply going to00:27:33
delete the last record entered and the00:27:36
last thing we would be left with is simply00:27:38
adding some messages at the end00:27:40
telling us that00:27:41
the data was successfully saved and00:27:44
that For example, if we want to enter00:27:46
empty data, for example, if I00:27:48
copy this right now, look, I save empty data00:27:51
and it should not allow saving empty data. We are00:27:53
also not going to00:27:54
control that, but simply first we are00:27:56
going to do the delete button00:27:58
last with this that we achieve. The00:28:00
last record entered, for example, in00:28:02
this case is blank, we can00:28:04
delete it and we are going to be a very easy00:28:06
programmer. In the same way,00:28:08
record macro and we are going to put delete00:28:11
last. If I say accept00:28:15
and that's it, the macro is being recorded and00:28:17
it looks like I locate myself here I locate myself here I00:28:20
select from here just as one said a00:28:23
while ago but now once00:28:25
everything is selected I right click and00:28:27
on the little arrow and say delete rows from00:28:30
the table delete the last one has been deleted I00:28:33
locate myself here so that remove it faint00:28:35
it's marked come back here I00:28:39
'll leave it there and say have it and that's it00:28:42
now I'm simply going to assign the button00:28:46
the macro that was called00:28:48
delete last that's what it's called they're going to00:28:52
accept that's it ready let's see my00:28:55
database says it doesn't I'm going to add a00:28:57
blank one first I say save I'm going to00:28:59
add the blank data notice it's00:29:01
here if I want to delete00:29:05
delete and ago it deleted me we're also going to00:29:08
remove it's palpa de look we have José Sánchez00:29:10
from the last delete last00:29:12
that was already deleted look it was deleted to00:29:15
josé sánchez delete was deleted and00:29:19
the last records00:29:21
entered are being deleted now well we are simply going00:29:24
to modify something so that we will not be able to save00:29:27
the data if it is entered so there00:29:30
is no registration number that is, if00:29:32
there is no ID we are going to say that it00:29:34
cannot be saved yes or it can be ID and00:29:37
name in this case no, it is c7 and00:29:41
EEC 9 if there is no ID or name that00:29:44
allows us to save for that I have here I00:29:47
have already copied I am going to copy this code00:29:50
from here It is not the code that allows me00:29:53
to do this and we are going to modify something00:29:56
simply in visual basic code00:29:57
something very simple we are going to visual basic and00:30:00
here notice I am going to close this and I am going to00:30:04
make this one here a little bigger00:30:07
and I am going to get out of here first I'm going to00:30:10
get out of here and I'm going to click here00:30:13
right click and I'm going to say see code the00:30:17
data entry not here in data entry00:30:20
here we are module00:30:23
and we are here now that's the name of our00:30:28
our module we are in00:30:31
data entry and Here we are in the00:30:33
double-click model, here the three00:30:34
macros that I have appear. Look, I have the00:30:36
recording macro, it is called recording. I have a00:30:40
macro to clean data that the only thing it00:30:43
does is clean my report. Somebody says00:30:46
clean and that's it. It doesn't select me and me. gives00:30:49
the value of empty has been empty and the00:30:52
last one that tells me to delete last what it00:30:56
does is select from the00:30:57
database and eliminate them from limits. Look at00:31:00
the row so what I'm going to00:31:04
do is place myself at the top and here I00:31:08
go to paste the code that00:31:11
tells you what this code does00:31:13
this code asks well here we are going to00:31:16
change we are going to see the same board 700:31:18
we are going to ask if cell j 700:31:21
vice range j 7 the value of that cell is00:31:23
empty in my case let's see what value00:31:27
was there is j 7 s00:31:29
7 if you feel where is the headquarters let's00:31:32
ask if 6-7 2/7 is empty00:31:37
then you can't record the data00:31:41
to let me connect the stuff I'm00:31:44
with low battery00:31:48
ok then it tells me if it is00:31:51
empty00:31:54
we are going to say that00:31:56
the data cannot be saved and we are simply going to get out00:31:59
of the routine and we are going to record00:32:04
I say00:32:07
and now it is missing I am going to return to00:32:10
excel it is missing save of the00:32:12
file with this that we achieve that if00:32:14
I put save look what I get,00:32:17
the data cannot be recorded because they are00:32:19
empty, be careful with the saved file,00:32:21
save as it is important to save as,00:32:25
since it is a file that contains00:32:27
macros, we must choose in examine the00:32:31
option in file type we are going to00:32:34
choose this one that says excel workbook00:32:36
enabled for macros otherwise00:32:39
the frames will not work for us it is00:32:41
important that excel workbook enabled00:32:43
for teachers or database template00:32:47
that's what I'm going to call it database template00:32:49
Now that's it, I say, save, I'm going to00:32:53
save it in one drive database template,00:32:55
save, it's00:32:59
been saved like this, I return here to the00:33:01
source code00:33:04
in the code,00:33:06
if I close I'll be able to save it00:33:08
calmly, I'll save it, I won't00:33:10
get any errors and the blinking that you see00:33:13
I said a while ago I also have the00:33:15
code here because it is only this line00:33:17
here, not application screen updates, I say00:33:20
copy, I set it equal to false so that it does00:33:23
n't make that blink and I'm just going to put it00:33:24
here, I say paste and with this I00:33:30
save and return and I'm not going to make00:33:34
that blink that we saw a while ago. I'm not00:33:36
going to fill out data for you to see.00:33:41
I'm going to put anything in the name.00:33:43
The sex. I'm going to put yes. Female.00:33:53
city,00:33:56
whatever, and the marital status, I00:33:57
'm going to give it, for example, the moment00:34:00
that I put, save, look, that flashing didn't00:34:02
appear anymore, no,00:34:05
that flashing that you saw a while ago didn't appear,00:34:07
and the data is well saved, look, it00:34:09
's already saved here now. We simply00:34:12
have to put the message at the end,00:34:14
right click, I say the code and I am going to put the00:34:19
message at the end of the saving that00:34:22
tells me that the data was saved00:34:23
successfully and here I am going to put00:34:26
a00:34:28
message msg box and I am going to say00:34:33
the data was saved00:34:38
satisfactorily I00:34:40
close they did nothing more than that I00:34:44
save and return00:34:47
and I'm going to save again look at the00:34:50
equality data not satisfactorily00:34:51
accept notice00:34:53
I'm going to delete the last00:34:57
record it was deleted here I also have00:35:00
to put that flicker on it I'm not going to00:35:03
delete the flicker see00:35:08
this code Here I00:35:10
am going to copy this code from here and I am00:35:13
going to paste it in the delete button,00:35:15
clean data, not here in delete,00:35:19
here I am going to paste it, I say paste so that it does00:35:22
not flash, I save it and00:35:25
return, delete, it has already been deleted, it00:35:30
gives us delete 2 + delete delete00:35:34
notice it was already deleted added save00:35:36
or add that it is the same saved00:35:40
accept that they saved the two data for me and I am00:35:43
simply missing here in this code00:35:45
in visual see if I am going to add a00:35:47
message after deleting the data00:35:49
that tells me00:35:52
that the data deleted00:35:54
successfully if data deleted00:36:01
successfully00:36:05
the data deleted successfully00:36:08
and ward00:36:10
ready I close00:36:13
if I put delete now it tells me data00:36:15
deleted successfully look we00:36:18
have it and here I can continue adding00:36:20
data added to extractor and mind it was00:36:23
added and I can clean to continue00:36:27
adding faster00:36:29
ready my friends that's all we have00:36:32
the template ready you can start00:36:34
using it download there you can00:36:36
use it so you can start filling in00:36:37
data and creating your own00:36:40
registration database of whatever you like and00:36:43
with this form with this format quite00:36:46
nice enough friend, you already know, friends,00:36:49
I hope you give it the appropriate and00:36:51
correct use, thank you for your likes, leave your00:36:54
comments and see you here00:36:56
next Friday with chapter00:36:59
number 4 of the basic excel course,00:37:03
it's a pleasure friends to have seen you, you liked00:37:06
the status with you and see you until00:37:09
next time [Music]Description:
Como realizar un FORMULARIO de INGRESO DE DATOS para crear una BASE DE DATOS con botones personalizados y completamente adaptable a cualquier tipo de dato. Descarga mi catálogo completo de videos cortos aquí: https://www.elingefrancisco.com/product/catalogo-completo-de-videos/ Link de descarga de la plantilla: https://mega.nz/file/uVxyCIhI#uzz7PxnoEnNgjlL4JsQyU7v5b2WD71EDnq3elg-8vtY ____________________________________________ No te olvides tambien visitar: Cómo crear un #CONTROL de #VENCIMIENTOS con #ALERTAS 🚦dependiendo de la #FECHA Y EL #PAGO: https://www.youtube.com/watch?v=rZCpr0ao0EQ Cómo crear un #CONTROL DE #INVENTARIO dinámico con y 🤑 #STOCK: https://www.youtube.com/watch?v=xPgY1sVAajw ¿Cómo hacer un #PANEL de #CONTROL de #ACTIVIDADES y #PROCESOS interactivo con porcentaje de avances?: https://www.youtube.com/watch?v=DTO_PiPB0Sk ____________________________________________ Paypal para colaboraciones: https://www.paypal.com/paypalme/FranciscoTeran?locale.x=es_XC ____________________________________________ Sigueme en mis redes sociales: Twitch (DIRECTOS) Próximamente: https://www.twitch.tv/ElingeFrancisco TikTok: https://www.tiktok.com/404?fromUrl=/elingefrancisco Instagram: https://www.facebook.com/unsupportedbrowser
Preparing download options
* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."
** — Link intended for online playback in specialized players
Questions about downloading video
How can I download "Como crear una #BASE DE #DATOS en #EXCEL con #FORMULARIO y botones personalizados SIN #PROGRAMACION" video?
http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.
Which format of "Como crear una #BASE DE #DATOS en #EXCEL con #FORMULARIO y botones personalizados SIN #PROGRAMACION" video should I choose?
The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.
Why does my computer freeze when loading a "Como crear una #BASE DE #DATOS en #EXCEL con #FORMULARIO y botones personalizados SIN #PROGRAMACION" video?
The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.
How can I download "Como crear una #BASE DE #DATOS en #EXCEL con #FORMULARIO y botones personalizados SIN #PROGRAMACION" video to my phone?
You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.
How can I download an audio track (music) to MP3 "Como crear una #BASE DE #DATOS en #EXCEL con #FORMULARIO y botones personalizados SIN #PROGRAMACION"?
The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.
How can I save a frame from a video "Como crear una #BASE DE #DATOS en #EXCEL con #FORMULARIO y botones personalizados SIN #PROGRAMACION"?
This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.
What's the price of all this stuff?
It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.