Download "Débuter avec Excel VBA Bonne pratique de codage"

Please wait. We're preparing links for easy ad-free video watching and downloading.

Next video: comment créer un mot de passe et utilisateurs avec excel vba | Tutoriel Excel - DE RIEN

0:00

Début

0:29

Bien nommer les procédures

6:56

Utiliser l'option explicite

10:30

Commentaire des codes

13:15

Code bien lisible

16:39

Traitement d'erreur

comment créer un mot de passe et utilisateurs avec excel vba | Tutoriel Excel - DE RIEN

comment créer un mot de passe et utilisateurs avec excel vba | Tutoriel Excel - DE RIEN

Channel: Tuto De Rien

excel debutant

excel 2013

excel

tuto excel

formule excel

de rien

tutoriel excel

cours excel

excel pratique

cours excel pour debutant

formation excel

débuter avec excel vba

excel de rien

Des cours Excel et tutoriel Excel avec TUTO DE RIEN

cours excel gratuit

crous excel online francais

excel vba

excel vba pour les nulles

formation excel gratuite en francais

bonne pratique de codage

comment bien coder en Excel vba

00:00:01

with excellent wine we are going to see

00:00:03

some good coding practices

00:00:04

then these good decoding practices

00:00:06

we are going to see without which I find

00:00:08

rather important but there is no

00:00:10

general rule that describes how to

00:00:11

really code cleanly if However,

00:00:14

you have other methods of good

00:00:16

practice, share them with us in

00:00:18

the comments

00:00:19

and we'll get started, let's go

00:00:25

[Music]

00:00:31

so here I created a little code which

00:00:33

works but which is not really

00:00:35

properly laid out and we are going to see

00:00:38

how to make it clearer so

00:00:39

schedules see what happens here when

00:00:41

the pi so we go here we are going to launch the

00:00:43

code we press a year and a message which is

00:00:46

displayed so there it is indeed marc canon

00:00:48

in the daniel and move into my 36

00:00:51

did ok so there is a member daniel 36

00:00:55

ski and add a database interval

00:00:57

and that's what the coach

00:00:59

gives here but it's not showing you

00:01:01

clearly what does so we see here we

00:01:03

therefore see text box an expo tree that

00:01:06

two lines and xd have seen ddl it is

00:01:09

not really clean is clear

00:01:11

what is happening in our side here

00:01:13

then something very important

00:01:16

is good named these procedures the

00:01:19

reason why it is important to

00:01:20

name these procedures well

00:01:21

is that it will be easier to remember

00:01:24

what these procedures are for is the same

00:01:26

thing for objects this means that

00:01:27

here we have a text bouxin m

00:01:29

textbooks two so it's this one only

00:01:31

textbooks 1 and the best thing to do is to

00:01:34

come and try to change that between txt that

00:01:37

means boxed text in fact we make a

00:01:39

bottom bar we write what is it so

00:01:41

it is a boks text does not have so here we are going to

00:01:44

find the name and especially for the purpose of

00:01:45

coming and changing that here also standards so

00:01:47

we are going to find everything that is text and

00:01:49

one in txt point bar at the bottom so we

00:01:56

had said for the following the hand we

00:01:59

are going to change in txt unfortunately in model date

00:02:03

or in a game earlier it was here age

00:02:06

then to come and if doubleclick that we are going to

00:02:10

change text in excess

00:02:18

age here so now that we have a

00:02:23

meaning we will be able a little set the

00:02:26

others here so the text boxing and if it

00:02:28

would be good text box txt no and texter

00:02:35

age it's one thing not to forget the

00:02:39

condition here too so that too we're going to

00:02:42

change it so it becomes txt no and txt

00:02:51

age we do not cancel others it is

00:02:54

perfect so the ace is never more readable we

00:02:56

can read that therefore if the long text

00:03:01

box name is empty or the text boxa g8

00:03:04

then we inflict message a

00:03:06

name is missing otherwise dlt gallard and a day

00:03:09

or even what happens according to her x y

00:03:11

is equal to so the

00:03:22

empty and the breakage

00:03:24

purchases very quickly also afterwards

00:03:28

then something else counts to

00:03:30

improve also we saw that we know that

00:03:32

those no we can change this one in

00:03:36

my name is this one in age otherwise that we

00:03:44

replace the name the age names and ages and we

00:03:56

see it works by sifting nothing more

00:03:58

it shows me the messages hours

00:03:59

a name is missing while if I come here

00:04:02

and unions number of places york bob

00:04:07

36 years old broke and the cheek inside so it

00:04:10

works perfect so at the glance so

00:04:12

it is much clearer including text and

00:04:14

no we know that it is the boxed text which

00:04:16

is there and therefore the boxed text

00:04:18

therefore becomes a certain name which is

00:04:20

found here of water and so we therefore

00:04:21

defined that the name of these texts is doctor

00:04:23

we subsequently

00:04:25

here again the last thing that we can

00:04:26

change these dlc which I use a lot

00:04:28

personally too so it's

00:04:30

wings or dlt it means last line

00:04:32

of back row of the table to make

00:04:35

the code clearer 1 it is better to

00:04:38

try so change without in

00:04:42

1st line but that makes it rather big

00:04:48

that's why I use dl but

00:04:50

hey we can always use the frr

00:04:53

line there you go and it's also then line

00:05:06

here and again the strong and here I

00:05:18

think that everything is put in so we're going to

00:05:20

try so we're going to do

00:05:23

nice ne and it therefore already works and

00:05:30

sierra that by naming so rule by

00:05:32

changing the text gave a proper name

00:05:34

for our commands and our orange variables

00:05:38

the code is much more readable so here

00:05:40

we see text area no and video

00:05:44

these old text areas empty after that

00:05:46

we put the message a name is missing a

00:05:49

name or an age in full boom and civil

00:05:53

in then last line 1 is equal so

00:05:59

here we are going to define last line so the

00:06:02

name has created a variable no which will

00:06:05

therefore include the text and not h texter

00:06:07

age

00:06:08

and that's it then here yves rent b1 is equal

00:06:14

to nothing then the line b is the number

00:06:19

last two lines who wrote here

00:06:21

more to say heart it will arrive here

00:06:25

there was so there we understand

00:06:27

perfectly what is happening your equal

00:06:29

to members here your equal to the name and your

00:06:31

equal to the hauling

00:06:34

we know that in say we are going to place

00:06:36

the arranged is launched we are going to place the name

00:06:39

otherwise well 6 and 17 cases it is not empty

00:06:42

we are going to put therefore members in the b to

00:06:44

put the name in his confessions m the age

00:06:47

in 1

00:06:49

and when it's over with tonight ah

00:06:51

well we're going to empty the text box no it

00:06:54

textbooks age

00:06:57

and since we are busy with the

00:07:00

variables here it is strongly recommended

00:07:02

to use the explicit option which will

00:07:05

check that each variable is well

00:07:07

declared in our code

00:07:10

we are going to take the example here

00:07:12

we are going to do we are going to

00:07:14

indicate above our code while in

00:07:16

our camp we are going to put the option

00:07:17

so it is called options explains aids

00:07:21

and even if this is possible

00:07:23

so there we have seeing our code works we

00:07:24

touched on what we were able to do and we are

00:07:27

therefore going to mark so daniel marked 6 4

00:07:31

commscope in directly an hour you

00:07:35

saw the code previously working

00:07:36

now that the friend of the

00:07:37

explicit option it gives us therefore gives an error

00:07:39

it tells us that the variable but we are

00:07:41

therefore defining the last line is not

00:07:43

defined basically that means what

00:07:46

the explicit option will control therefore

00:07:48

each variable that we have written in our

00:07:51

piece of code

00:07:52

when this variable is not declared

00:07:54

it will give us an error saying

00:07:56

to be variable is not declared there is

00:07:58

an error here and it is if it is to

00:07:59

avoid that we pass an error that

00:08:01

means that we take an example if we are going to

00:08:03

mark the said she we said go

00:08:06

take the dim and therefore mark

00:08:11

earth line as a small mouth

00:08:18

so there I declared my variable

00:08:20

now we are going to launch at the bottom what

00:08:23

happens to there found another variable

00:08:25

which but not defined yes we

00:08:27

declared the variable no and we

00:08:29

said that we had to add in the name the

00:08:32

box text which is located here so the text

00:08:34

boks did not have sigma is therefore we must

00:08:35

declare the world so here we are going create

00:08:37

a statement said tim name a

00:08:42

string of the content of the text in a and

00:08:47

send what happens now it's

00:08:49

the age that poses a problem but here I

00:08:51

want a number so we do so said ms

00:08:53

h as in tieger we will test and there everything

00:08:59

works there added there is no problem

00:09:01

now show something

00:09:05

special also with this

00:09:07

explicit option let's say that we learn

00:09:08

to indicate

00:09:09

suddenly in it and we do not have the exclusive option

00:09:13

so that I remove it we don't have it and at some

00:09:15

point if I don't put no but I

00:09:17

now and we're going to see what's going to

00:09:20

happen we're going to add here

00:09:23

bob we'll put an h 21 years old do ok and

00:09:29

we see that he said qu is member 21

00:09:31

but he did not indicate the name bob

00:09:33

why quite simply I did not see

00:09:35

I did not pay attention that I

00:09:37

wrote my variable wrong sindh in is therefore

00:09:40

excellent to simply continue

00:09:42

do not did not stop there and did not check

00:09:44

whether the variable was declared or not or whether

00:09:45

this variable existed so in

00:09:47

fact if we do not declare a variable,

00:09:48

that is to say that the variable should

00:09:49

not exist on the other hand if it would have put

00:09:51

the explicit option so option if you

00:09:57

see there and I restart and the code and

00:10:03

I would have launched the code it would have detected

00:10:05

media director here there is an error the

00:10:07

variable it says finished so I would not have been

00:10:09

able to move forward in my code

00:10:11

so here I am going to mark no of course we

00:10:14

are going to launch the cot and what it does

00:10:18

the control everything works nickel

00:10:20

language here now if I bring it into

00:10:21

its game but bob 4 I am ok it adds

00:10:29

two teeth perfectly

00:10:32

then it is It is important, especially when

00:10:35

we are going to tackle a long series of

00:10:36

codes, to comment on them carefully, Cécile, in order

00:10:39

to remind us what the pieces of

00:10:40

code are for that we have made a total

00:10:43

when we are going to create a program and we

00:10:46

are going to come back to it later, so

00:10:47

here ten days from now to two weeks from the

00:10:49

Siamese that we remember what we

00:10:52

did there it's really important

00:10:54

so what I like is it's a little

00:10:57

organized so but comment here

00:11:01

I therefore mark here I put the

00:11:05

declarations of variables here I

00:11:10

declared but Bryant never has to

00:11:11

declare but variable here here we do

00:11:15

what and if we therefore indicated that

00:11:19

put it next to check if all

00:11:30

the information is there that's

00:11:38

if they still reject a little code

00:11:40

also we're going to say that if our first

00:11:44

empty line added a dogn boss

00:11:58

that's it and if we can indicate if the

00:12:06

first line is empty added to the

00:12:17

database the comma

00:12:32

- symbol c' is this what we need

00:12:37

here so we can therefore indicate a void and

00:12:43

the dexter zones and so in

00:12:50

a while on one side

00:12:51

our code and we wonder but what was it

00:12:54

again this is what is what we

00:12:55

did there for nothing we can remember here

00:12:57

check all the Varois are the top

00:12:59

our cutter our first line is

00:13:01

not empty must we add it's in if

00:13:03

the first line is obvious but that

00:13:04

's not it sincere to empty therefore our

00:13:06

our text areas

00:13:07

we place information if ever

00:13:09

the peter center coast relay in its

00:13:11

premises what were the bits of

00:13:13

code that we placed for

00:13:16

then we placed our comments

00:13:18

it is also essential moreover of a

00:13:20

well readable code there we can see it's

00:13:23

a big block it's difficult to say it's

00:13:25

not practical at all eh we

00:13:27

really risk crashing if they are going to

00:13:29

do something or modify

00:13:31

things it will make this grow page and

00:13:34

we have a little more structured foot and

00:13:36

how quite simply by adding a

00:13:38

new line so here page of a

00:13:40

new line there it is a condition it

00:13:43

makes it is the first of which everything that

00:13:45

is here we will move it forward

00:13:47

here it belongs in the first

00:13:50

condition it is also there there there there there there is there

00:13:57

so there is already therefore

00:14:01

an if so the first condition if

00:14:04

it is everything is blocked and it is much

00:14:06

more readable than there just now like

00:14:08

it was before it was like this is

00:14:13

really difficult to distinguish the

00:14:16

first block of sea is the second block

00:14:19

of 6 42 blocks of 6.6 and it's really

00:14:21

difficult to distinguish them where what

00:14:23

will be the first success the second is

00:14:25

so quite simple gesture

00:14:27

we have already defined so we have

00:14:30

made our block so visible in a

00:14:34

single blink of an eye we will see how this

00:14:35

site of a leaf block directly to the king

00:14:37

that's a condition

00:14:39

we have a second condition that 'they

00:14:41

say he went to move forward also

00:14:42

as we did there thaler hop there you go there

00:14:45

there you go on

00:14:50

the other hand they are moved back there

00:14:55

there you go there

00:15:00

there it actually has an entrance and there

00:15:04

too we bring in and we see a

00:15:06

second block of a condition which is

00:15:09

here this is a second block really

00:15:11

very clear very easy to read so

00:15:14

when I also like to make its

00:15:16

guards and including all my declarations of

00:15:18

variables at the top one which we can also do

00:15:20

it' is obligatory but we can

00:15:36

separate the blocks but here we drink

00:15:44

you see here it becomes quite large and

00:15:46

it really becomes alain so large code

00:15:48

which is not worse

00:15:50

at least it is clearly visible is this if

00:15:57

we can therefore place it in top

00:15:59

also in English not obliged to put

00:16:01

here we see the spacer otherwise in the

00:16:03

declaration two variables and then we

00:16:04

can mark in two

00:16:09

variable configurations and royal configuration we can

00:16:13

take them and if cut we can move

00:16:16

6 1 6

00:16:23

we therefore have non variable of

00:16:26

confusion of trips which are grouped

00:16:28

if we have classes have

00:16:29

reactions to group together shortly because as soon

00:16:36

as a single line

00:16:37

enters

00:16:41

then one last thing that we must

00:16:43

do and it is really also a good

00:16:44

practice and it it's quite simple to avoid

00:16:48

problems it's to place a

00:16:49

processing behind in each

00:16:51

procedure to the functions that we do in

00:16:54

the error processing part you

00:16:56

can find how to put an

00:16:58

error processing in place so the

00:17:00

link you go find at the top in

00:17:02

the video you just have to click on it

00:17:03

and you will not go to the

00:17:05

processing part of the mango laughers we will come

00:17:07

here and we will add another

00:17:13

error processing we will say in gold

00:17:18

other errors like this so we will make a

00:17:22

exit seube and therefore placed our error

00:17:27

therefore errors but we notice that error

00:17:41

here so if an error it will file

00:17:44

taylor is therefore from now on if I put a

00:17:46

man therefore daniel and I forget to put

00:17:49

the gauge but a text in it reflects

00:17:52

therefore terror type 5 right 4 and so on

00:17:55

what that is so we saw

00:17:56

how we rendered a code like

00:17:58

that in block and to have really readable

00:18:00

a much cleaner code a

00:18:04

much cleaner dildo like this one

00:18:06

that we can see so a lot more

00:18:07

structured it is much more visible

00:18:09

is much easier to decipher

00:18:11

also afterwards

00:18:12

and well here is this long series of

00:18:14

commands and mutek excel vba ends

00:18:16

with this video

00:18:17

I hope you liked it and that

00:18:19

from now on you are able to better

00:18:21

understand coding in excel vba

00:18:23

if you still have questions let

00:18:25

me know in the comments or

00:18:27

on my facebook page

00:18:28

until then I will see you in a

00:18:30

next video in the armpit everyone

Description:

Dans cette dernière partie de débuter avec excel vba. nous allons voir quelque bonne pratique de codage. alors ces bonnes pratique de codage que nous allons voir sont ceux que je trouve important. mais il n’y a pas de règlement qui décrit comment vraiment coder proprement. si toutefois vous avez d’autre méthode de bonne pratique partagez le avec nous dans les commentaires. site web : http://www.tutoderien.com Facebook : Facebook.com/tutoderien Twitter : @tutoderien abonnez-vous à la chaine et on se retrouve pour une prochaine vidéo

Preparing download options

Popular

HD video

Only sound

All

* — 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 "Débuter avec Excel VBA Bonne pratique de codage" 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 "Débuter avec Excel VBA Bonne pratique de codage" 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 "Débuter avec Excel VBA Bonne pratique de codage" 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 "Débuter avec Excel VBA Bonne pratique de codage" 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 "Débuter avec Excel VBA Bonne pratique de codage"?

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 "Débuter avec Excel VBA Bonne pratique de codage"?

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.