MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_aTGH1E4gpd0 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
I've got to say I've been using books and youtube videos to learn to do VBA and you are by FAR the best youtuber for this.. You are clear concise and teach at a great pace for actually learning how to do the scripting. Too many times people make videos on this stuff assuming that the level of knowledge is equivalent, so there is very much the "just do this and this and this, it's easy" I appreciate that you take time to explain what you are doing while you show the step. Thanks!
Thank you for your comment! That is such a nice thing to hear that you like my pace and method of teaching!!!!!! I struggle a lot with the temptation to breeze through things, so hearing that my pace is appreciated is great to hear :) I am in the process of finishing up the full VBA course on TeachExcel.com and I think you will find the pace and structure very easy to follow as well. Every tutorial comes with a heavily commented file that explains exactly what is going on and why and I did this specifically so you never get to a point where you wonder what is going on. If you want, you can sign up to be notified when its released here: www.teachexcel.com/vba-course-update.php
I'm working on a premium course right now, but that won't be finished for a month or two, you can signup to be notified when it is finished here: www.teachexcel.com/vba-course-update.php
You are really good with your explaination, you have made it really simple. Wish you had posted all the advanced tutorials..if you have plans please do let me know... overall excellent learning. Thanks again.
I'm glad you like it! I'm working on a bigger macro course right now and if you want to be notified when it's released, you can signup for the newsletter on teachexcel.com
How can you set the active cell to the one the user selected? That way you have the value of the cell they selected and the cell they selected is also the current active cell
Hi!, I was wondering if its possible to have a macro that writes the name of the sheet for the month and change for the current month each time o use the macro? Tx in advance
sir ever after using on error resume next and on error goto 0 when i cancel the range selection input box the same error msg. is popping up to me. I am using MS 365 fyi. How to solve this problem. please help..
"Exit Sub" Say it ain't so!!! Don't encourage bad habits and lazy programming . You did a nice job with the comments; especially listing the values for the type parameters. A sub should have one way in and one way out. Other than that very informative, clear, and concise.
I'm really trying to get people comfortable jumping-in, creating macros and seeing immediate results, and then add-in best practices a bit later. I've found that if I try to throw too much at someone too quickly that it gets a bit difficult to follow. Thanks for the comment! :)
Just curious (and I know this is a super old comment), but can someone explain why this is 'lazy' to do? What would be a good follow up to see the proper way of doing this? Thanks
Hi there! I think my series on making a more professional form should help - the VBA stuff starts on video 5 I think - ua-cam.com/video/9j8mAJGFWPg/v-deo.html
MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_aTGH1E4gpd0
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
I've got to say I've been using books and youtube videos to learn to do VBA and you are by FAR the best youtuber for this.. You are clear concise and teach at a great pace for actually learning how to do the scripting. Too many times people make videos on this stuff assuming that the level of knowledge is equivalent, so there is very much the "just do this and this and this, it's easy" I appreciate that you take time to explain what you are doing while you show the step. Thanks!
Thank you for your comment! That is such a nice thing to hear that you like my pace and method of teaching!!!!!! I struggle a lot with the temptation to breeze through things, so hearing that my pace is appreciated is great to hear :) I am in the process of finishing up the full VBA course on TeachExcel.com and I think you will find the pace and structure very easy to follow as well. Every tutorial comes with a heavily commented file that explains exactly what is going on and why and I did this specifically so you never get to a point where you wonder what is going on. If you want, you can sign up to be notified when its released here: www.teachexcel.com/vba-course-update.php
Your explanations are very clear and well. could you please continous sharing macro videos to class7, 8, 9... etc.?
HI, why did you stop at class six please
@@vincentcharagu2919 There is no class 7 forward, at least I cannot find them in youtube
I'm working on a premium course right now, but that won't be finished for a month or two, you can signup to be notified when it is finished here: www.teachexcel.com/vba-course-update.php
@@vincentcharagu2919 It does seem to leave us in the lurch. I was just beginning to get a grip on things.
Respected sir, I have downloded 1 to 6 videos, l have like it too much, thanks a lot sir.
You are really good with your explaination, you have made it really simple. Wish you had posted all the advanced tutorials..if you have plans please do let me know... overall excellent learning. Thanks again.
It is possible to run inputbox and keeping control on excel ?
Could you explain how to handle the error that shows up when the user does not enter anything and clicks the OK button on the input box
Sir, I need some help selecting sheets by input box VBA code.
👍👍Very very good videos. I thinks you need to continue the series for more videos to vba. It will really helps us. Thanks for this!
I'm glad you like it! I'm working on a bigger macro course right now and if you want to be notified when it's released, you can signup for the newsletter on teachexcel.com
How can you set the active cell to the one the user selected? That way you have the value of the cell they selected and the cell they selected is also the current active cell
Is it possible to arrange inputbox as 12x1250x2500 ?
Good day! Tell me how I can enter the date through the inputbox method of data entry with the possibility of further processing in the code. Thank!
However you want. Just let the user type in the date in the format that you tell him to type it in. Then, check for that format in the code.
Hi!, I was wondering if its possible to have a macro that writes the name of the sheet for the month and change for the current month each time o use the macro? Tx in advance
sir ever after using on error resume next and on error goto 0 when i cancel the range selection input box the same error msg. is popping up to me. I am using MS 365 fyi. How to solve this problem. please help..
It can only take max 255 char . How to increase it to 1024 atleast
please share video for this
I would like to have the input box pop up, and if I type 12.3 into the box, I'd like it to put 12.3 into the selected cell. Is this possible?
Yes something like: ActiveSheet.Range("A1") = inputValue
This picks a set cell on the active sheet.
"Exit Sub" Say it ain't so!!! Don't encourage bad habits and lazy programming . You did a nice job with the comments; especially listing the values for the type parameters. A sub should have one way in and one way out. Other than that very informative, clear, and concise.
I'm really trying to get people comfortable jumping-in, creating macros and seeing immediate results, and then add-in best practices a bit later. I've found that if I try to throw too much at someone too quickly that it gets a bit difficult to follow. Thanks for the comment! :)
Just curious (and I know this is a super old comment), but can someone explain why this is 'lazy' to do? What would be a good follow up to see the proper way of doing this?
Thanks
can you make a project or something by using VBA Code, that would be really helpful and give us new ideas.
Hi there! I think my series on making a more professional form should help - the VBA stuff starts on video 5 I think - ua-cam.com/video/9j8mAJGFWPg/v-deo.html
@@TeachExcel excellent .
where is class 7?
I wasn't sure how much demand there would be for it so I didn't do it yet :/
@@TeachExcel Class 7 Please!
@@TeachExcel yeah please
yes please: 7, 8, . . . .
@@TeachExcel Please release class 7,8,9.....