Excel VBA Beginner Tutorial

Excel VBA Beginner Tutorial

Learnit Training

5 лет назад

5,470,402 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@johannesmp3
@johannesmp3 - 08.10.2024 14:17

Gr8 video, but you forgot to show us the code that the macro recorder shows us. Another thing is the lock cells. Unlocking the numerical cells indicates that they have been locked in the first place. Other than that, it's a great beginners course which had stuff of which I was unaware. Such a great voice

Ответить
@r_s7927
@r_s7927 - 14.10.2024 12:36

In VBA simple macros exercise file , its showing file is untrusted , so i am not able to run any macro in it . The error shown as - Because of Security settings , your macros have been disabled. To run macros , you need to reopen this workbook and choose to enable macros. However ,. i tried reopening the workbook and i checked the enable macros option but its not working for me ..

Please help !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Ответить
@rafaelfilipe6495
@rafaelfilipe6495 - 15.10.2024 18:58

thanks

Ответить
@mosaf8006
@mosaf8006 - 17.10.2024 22:53

40.39 last watched

Ответить
@movieshorts3129
@movieshorts3129 - 18.10.2024 07:41

Your voice is just 💯

Ответить
@mohamedsours8175
@mohamedsours8175 - 19.10.2024 20:53

Thanks a lot for your efforts. i just have one question plz
is it stell worth it learn Excel VBA in this ira of AI and its evolution ? Thank you very much 🧡

Ответить
@zerog1037
@zerog1037 - 23.10.2024 16:45

Why execute during the macro recording? Can't you just do all the steps and stop the recorder?

Ответить
@srinivasskumarmk4456
@srinivasskumarmk4456 - 29.10.2024 22:04

Best VBA course I have ever seen. Cant wait to start the advanced and expert levels.

Ответить
@tiburciouetela5413
@tiburciouetela5413 - 31.10.2024 17:24

What a phenomenally good tutorial. Kept me coming back to learn more. Helped me feeling confident using VBA. Clear instructions, good examples. Thank you!!!

Ответить
@stanleyipkiss4046
@stanleyipkiss4046 - 02.11.2024 02:27

I’m watching your course today because this coding drove me crazy this afternoon

Ответить
@Mixos_7
@Mixos_7 - 03.11.2024 16:27

Thank you so much. The best tutorials I have ever seen 💜

Ответить
@johnbofarullguix1499
@johnbofarullguix1499 - 14.11.2024 07:28

why is Chelsea calling VBA pull down menus 'old fashioned' ? twice

Ответить
@johnbofarullguix1499
@johnbofarullguix1499 - 14.11.2024 07:29

is VBA being replaced by Typescript?

Ответить
@szabolcsbayer6169
@szabolcsbayer6169 - 22.11.2024 22:59

Is this AI voice? I am not sure but it's passing my Turing test if it is :D

Ответить
@kyleperez577
@kyleperez577 - 30.11.2024 14:46

This is much better than udemy.

Ответить
@muftahmohamed8963
@muftahmohamed8963 - 04.12.2024 20:02

My first time to spend as much time to learn VBA, well-structured material and it is straight to the point and easily understood. Thanks, a lot.

Ответить
@sebastiangillesberg
@sebastiangillesberg - 04.12.2024 20:57

Got to say this is the best tutorial I have found on Macros and VBA and the best part is is free.

Ответить
@olivia4087
@olivia4087 - 14.12.2024 13:46

Ive been using chat gpt to writ my macros and idk if this is worth knowing

Ответить
@fandedeto4603
@fandedeto4603 - 15.12.2024 18:51

Si seras, si seras, tomaaaaa

Ответить
@IanNjoroge-s9e
@IanNjoroge-s9e - 18.12.2024 15:42

123456789 M's in my bank account

Ответить
@arhanname8769
@arhanname8769 - 18.12.2024 22:22

The tone of your voice is mesmerizing
how beautiful you look ! with just your voice
I could listen to your lectures all day long

Ответить
@prashannashrestha6282
@prashannashrestha6282 - 24.12.2024 09:34

How do I enable macros in exercise sheet?

Ответить
@Digital010
@Digital010 - 28.12.2024 21:10

Not even an AI can explain things as good as she does!

Ответить
@yemparabhuvanaika340
@yemparabhuvanaika340 - 29.12.2024 19:23

great lecture ! I cannot find the simple macros file can you please share it

Ответить
@adityadayal3662
@adityadayal3662 - 01.01.2025 17:19

Thank you for providing with such great guidance for VBA! I want to ask that in the later part of the video we are learning about selection, range, value, etc. While all these tasks can be performed manually why are we doing is this way ?? What I think is like it will help us to debug or edits macros which are already there !!?? So is this why we are learning it ?

Ответить
@aleloyte
@aleloyte - 01.01.2025 17:59

For the editors. Probably there is an video editing mistake when the lady is giving an example about removing a part of the social security numbers. It's about 38 minute of the video. This part is showed twice, first time it's ending when she starts recording macro and then this part starts over again. Also I have one more question about that exercise . After making that steps I receive modified data but I lost the oryginal social security numbers because they are overwritten. Is that how it supposed to be?

Ответить
@wkrd-p4z
@wkrd-p4z - 01.01.2025 19:30

It is going to be an amazing course. And I am in an alert mode😕

Ответить
@wkrd-p4z
@wkrd-p4z - 02.01.2025 14:37

Hello instructor👋 How are you doing?
While practicing on the files, my macro is going a little bit crazy. What should I do? I am using Excel 2013.

Ответить
@wkrd-p4z
@wkrd-p4z - 03.01.2025 23:01

Hello, Dear, While practicing on the Exercise files, I encountered a problem. After recording a macro on the Phone column as you did, when I try to apply it to the whole column, it only applies to one cell despite my selecting the whole column. However, I recorded and ran the macro on the whole column successfully for the Birthday and SS# columns, and it worked correctly. What could you think caused this kind of problem?

Ответить
@joydeepp6521
@joydeepp6521 - 09.01.2025 07:37

Nice
Learnt something new

Ответить
@nasheedsbymishkaatsalman
@nasheedsbymishkaatsalman - 12.01.2025 13:40

Very beneficial, and thorough. Immediately understood it and started implementing

Ответить
@CRUZMAREALESTATE
@CRUZMAREALESTATE - 19.01.2025 03:07

Excellent training and instructor. Thanks so much!!

Ответить
@thiruppavaichandrasekaran2972
@thiruppavaichandrasekaran2972 - 21.01.2025 04:19

Exercise files not opening. It says that the file is having a virus or an unwanted software. Is there a way to open the files.

Ответить
@VishalKumar-rg9us
@VishalKumar-rg9us - 21.01.2025 20:53

Oh I think you sound a lot like Claire from Modern Family. And I can not unhear it now. The whole course is so nicely covered. Thanks a lot for this.

Ответить
@nitishpandey5893
@nitishpandey5893 - 27.01.2025 08:18

Hello i have downloaded the vba macros file and i am not able to do the editing and can't practice the macros it is showing that macros are disabled '

Ответить
@MYURBANESSENTIAL.
@MYURBANESSENTIAL. - 01.02.2025 13:23

Unable to find - Protecting and Formatting Sheets with the Macro Recorde ( in file

Ответить
@michaelkahsai8088
@michaelkahsai8088 - 06.02.2025 05:47

Thanks a lot for one-of-a-kind instruction!

Ответить
@IshranJahan-s2c
@IshranJahan-s2c - 09.02.2025 04:48

Your voice is very soothing and encouraging. Think I am gonna finish this course.

Ответить
@MsGoldenEra
@MsGoldenEra - 26.02.2025 20:26

Just want to say that you are by far the best online Excel tutor and I adore the fact that you provided us with the exercises so we can practically learn on the fly

Ответить
@yanxiafeng1262
@yanxiafeng1262 - 02.03.2025 13:16

谢谢,很详细,按操作完成了,非常感谢哈哈哈。👍

Ответить