I thought I knew a lot of Excel, then a realized it was Macros, so there's a new world to discover up, and you are helping me out with your videos. Thanks from México..
Your videos are awesome my friend! 3 videos in and already I have learned far more than books and paid courses could ever teach! Thank you for making VBA easy to follow
Thank you ever so much. Your tutorial is excellent. I bought a book to learn VBA but your tutorials are so good that completely outweigh the book I bought. Furthermore, the way I learnt how to code was long, in the sense of write everything, for example worksheet ("sheet1"). Range () etc. Your way of writing is much better, so straightforward! I like it!. I tried to learn for and next in the book but I got so confused- with your example I finally learnt it!
Another good video by Dan, and simple explanation and making it look all so easy, Good work. For the benefit of viewers, what they will learn in this video are - Loop For.. Next - Indenting to make easier reading - Performing calculation on variable - Date function and incrementing date - STOP - temporary pause to inspect the code run God Bless
Hello Danny, Just want to say a sincere thanks for all your uploads and for the time and effort that you have input and shared with us all. Your quality of videos are excellent and just like Mike so is the detail level. Please keep this standard up. Thanks to you and Mike I am at last enjoying excel again!!!
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Thanks for the videos, Dan! These are absolutely great. I've been trying to learn VBA for a few months now, and have been doing a little bit of coding at work, but your videos make everything very clear and I really appreciate that. Thanks again!
This is awesome. I have been trying to learn excel VBA from sometime with on and off interest but I believe I can do it with this channel finally. Thank you ExcelVBAIsFun and Dan.
for FREE my friend! Visit www.IncrediMail.com I really like modern versions of outlook better, but I used to use Incredimail and my dad still loves it. Cool backgrounds and emoticons are what incredimail is all about. Dan
When I first started screwing around with VBA, I never used the For...Next loops. I never knew that existed. I always did it like this: x=1 Do Cells(x, 1) = x x = x + 1 Loop Until x = 11 This is how I would loop through the first 10 rows. The For...Next loop looks much cleaner. Great video!
Carmel Not yet but what a great idea! What did you have in mind? Do you have some ideas to challenge yourself that I can share with others? Like a contest or just assignment type things? Thanks, Dan
Well, anything of that sort really. The point is I'm trying to learn for the sake of knowing at the moment, but just watching the videos is obviously not enough. I'd love any sort of assignments and a contest sounds like an ever better motivator.
After re-reading this, maybe you are talking about the font color, cause it starts black. Hmmm. . . please clarify for me specifically what you'd like. Thanks!! Dan
Hi, thanks for video, i have a question though, how to have each loop to execute (for example) to 5 rows? I noted in each loop u only apply to one cell.
Hi Dan, thanks for your reply, I have a question, loops work fine if with a limited number of rows, if we have a big database of 20000 rows are more, and would like to count a specific number of times a variable occurs in database along with certain criteria which qualifies that variable in them same row, then place that count in a cell. can you help me with this. Murali
Hi , I had a quick question. Let say I have a which contains the names of clients. Each client has on average 4 rows. However, the name is written on only the first row of that client. What can I do to make empty cells automatically fill with the name of the last filled row in that column?
hey im working on a persenal administration file ware i want to make a cel that starts black and if you click it it gets red if you click it again it getst green and if you click it one more time it gets to blank again and its in a list of cels that are clicble each seperate of eachother any help would be realy apriciate ty
Hello ExcelVbalsFun, I hope you are well. I have a question that I can not find the answer and I hope you can help. In your example "For x = 1 to 10". What if I wanted to be able to change the " 10 " element from the excel main sheet1. I am thinking like I would enter a value in a cell and the loop would run that many times. Or maybe a pull down or something. Any suggestions? Thank you
i like your videos , and i learn .i am beginer of vba . so its benefit for me. i face a problem on the chapter 3 ( for and next ) and loop . you have a any easy way to learn these chapter...
I have some issues here. I'm using Excel 2010 and following the procedure in this video to its exact detail, and I'm getting error message "Compile Error - Variable not defined". Am I missing something here?
I believe the reason is the Option Explicit button ON or OFF. He has it OFF for now, which do not make it mandatory for the user to declare the variable and vice-versa. Hope that helps. :)
Oh Just one question. I don't like to use cell, I prefer to use range. So is it possible to use range instead of cell in the for and next ,? Because,I did try it but didn't work
Hi! I have a VBA question. I have a bar graph showing the the number of sales every month for the last 5 months. For example: 1000 in Oct, 1200 in Nov, 1300 in Dec, 950 in Jan, and 800 in Feb The Months are in One row (Row A), the number of sales are in another row (Row B). Next month, I want to show the number of sales for (Nov, Dec, Jan, Feb, March) on the graph. The month after, it would shift again (Dec, Jan, Feb, March, April) and so on And then keep on repeating that as months go by (looping) How would I code that loop on VBA? I'm aware of the fact that I can manually change the range, but we are trying to automate the system so that there is no manual work needed (and this code will go in between many other codes that I already have) Thanks for the help!
Every Month I need to copy a range of data from one workbook to another workbook. In the column are the Months (Starting from April 18 till May 21). In the source file the Months are in row 2 (starting from E2, F2, G2, etc.) In the active file the Months are in row 5 (from CJ4, CK4, CL4, etc. till DU4).When the Month is ended I need to copy a range of 27 cells (row 3 till row 29) from the source file into the active file the column is based on the selected Month in cell (CI2) from the active workbook. The range is always 27 cells.So in the active workbook, I first select a Month (e.g. Aug 18) and then I click on a button to activate the copy function.At the moment I used IF, and ElseIf functions but this is a very long code. Can you help me to program a combination of a Vlookup with a loop function or something. There must be a much easier way to do this than I do now...right?Active Workbook Source file
I wish VBA programmers would use indentation. It's not just to make it pretty. Indenting code properly is key to reading and understanding the function and flow of it
Agreed. It really causes headaches trying to figure out what's happening in a large loop with a gazillion embedded IF THEN statements. Thanks for the comment!! :)
He probably has x defined as a Public object, meaning he can use that object anywhere. He probably should have mentioned that. To use x in this example you'd have to define it. Right under "Sub Test1()" put "Dim x as Integer"
can you use variable in the way that the for is changing the variable it self?: For k = 1 To 10 something & k = k Next k Well, this does not work - why?
its like a activation button that i can use to activate modules inside excel to count ore not to count i can send you a file ore we can skype if you want to give you a beter explenation the code is below
Yes, that's do-able, but a sample would make better sense. Can you make a sample workbook to share with me? I can use the sample data to respond and make a video. Cool.
If you're being forced to define your variable, you'll need to change your settings. It's EASY! Check out my video in my Basics Series. Video #17 is about that.The link is this, of course replacing dot with a period. youtube dot com/watch?v=Egf02zq95s8
I thought I knew a lot of Excel, then a realized it was Macros, so there's a new world to discover up, and you are helping me out with your videos. Thanks from México..
Thank God, I found this channel. So blessed to have someone like you teaching us vba for free. God bless Sir
Your videos are awesome my friend!
3 videos in and already I have learned far more than books and paid courses could ever teach! Thank you for making VBA easy to follow
Thank you ever so much. Your tutorial is excellent. I bought a book to learn VBA but your tutorials are so good that completely outweigh the book I bought. Furthermore, the way I learnt how to code was long, in the sense of write everything, for example worksheet ("sheet1"). Range () etc. Your way of writing is much better, so straightforward! I like it!. I tried to learn for and next in the book but I got so confused- with your example I finally learnt it!
Thanks Daniel for taking your time in making this video. God bless you greatly.
Another good video by Dan, and simple explanation and making it look all so easy, Good work.
For the benefit of viewers, what they will learn in this video are
- Loop For.. Next
- Indenting to make easier reading
- Performing calculation on variable
- Date function and incrementing date
- STOP - temporary pause to inspect the code run
God Bless
Hello Danny, Just want to say a sincere thanks for all your uploads and for the time and effort that you have input and shared with us all. Your quality of videos are excellent and just like Mike so is the detail level. Please keep this standard up. Thanks to you and Mike I am at last enjoying excel again!!!
Its 2019 and this tutorial is still relevant.
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Thank you so much! I can't wait to put my ideas into practice. I will be saving at whole lot of time!
Awesome! Very welcome!!
Amazing series of VBA Basic videos! Thanks, ExcelVbaIsFun!!
Thanks for the videos, Dan!
These are absolutely great.
I've been trying to learn VBA for a few months now, and have been doing a little bit of coding at work, but your videos make everything very clear and I really appreciate that. Thanks again!
Good job. Although I am yet to see some more advanced stuff but I like your channel as you are well descriptive and it is easy to understand
This is awesome. I have been trying to learn excel VBA from sometime with on and off interest but I believe I can do it with this channel finally. Thank you ExcelVBAIsFun and Dan.
So glad to have you, Ali! We try to make it fun because we absolutely love Excel VBA and I find it to be absolutely engaging and addictive myself!
Where can I get that email notifier !!??
Its so cool!
for FREE my friend! Visit www.IncrediMail.com
I really like modern versions of outlook better, but I used to use Incredimail and my dad still loves it. Cool backgrounds and emoticons are what incredimail is all about.
Dan
When I first started screwing around with VBA, I never used the For...Next loops. I never knew that existed.
I always did it like this:
x=1
Do
Cells(x, 1) = x
x = x + 1
Loop Until x = 11
This is how I would loop through the first 10 rows. The For...Next loop looks much cleaner. Great video!
Thank you very much Dan, and God bless you and your family Sir!
You too thanks!!
Thank you for these videos, they are very informative and very easy to follow along!
very informative and a learned a lot, looking for more videos
Great work....to be encouraged by Mike and dedicating your knowledge to us..You are really amazing...Thank you very much from the bottom of the heart
Wow thanks Surya!!! Dan
Thanks a lot, You explain it very easy. Greets from Germany
You're very welcome, Kai! thanks for the kind words!
Thank you, you are great I can learn it easy for 3 lesson already! Thanks from Cambodia
These videos are great. Please keep them coming. Do you have any videos focussed on importing stock data (more than just the price)?
Excellent! vid tutorial Dan; & very interesting.
I am learning a lot; in VBA basics.
Thank u 4 sharing.
Thanks for helping with these amazing tutorials!
You're absolutely welcome!
Thanks very much for these great videos.
Very welcome!
thank you for sharing this video and taking the time to explain us, I'm a bebinner in Vba but i'm working so strong
thanks for this great tutorial!
You're very welcome, marvin!
thank you. very informative and easily explained
Thank you. for some great stuff. You explained everything very nicely.
Hey superb videos.... I learnt alot from them.
Thank you so much, your videos are so helpful^^
these are real nice man! i'll be going through them slowly
Thanks Carmel!!
i was wondering, do you have things like assignments or anything i could practice with? maybe ideas for small projects
Carmel Not yet but what a great idea! What did you have in mind? Do you have some ideas to challenge yourself that I can share with others? Like a contest or just assignment type things? Thanks, Dan
Well, anything of that sort really. The point is I'm trying to learn for the sake of knowing at the moment, but just watching the videos is obviously not enough. I'd love any sort of assignments and a contest sounds like an ever better motivator.
Carmel Challenge #1 is uploading soon. lol You asked! Thanks Carmel. Dan
Thanks Dan, where is that do while loop example? :)
After re-reading this, maybe you are talking about the font color, cause it starts black. Hmmm. . . please clarify for me specifically what you'd like. Thanks!! Dan
?? Thanks, I'll take that under advisement. You're the first in 200K to mention this issue. Have a great day! Dan
Thanks mate. Very grateful for the vids
Thanks for the videos Dan!
Super teaching sir
How to do data entry using vba? How to enter coloum headers n rows in vba?
How do you get the yellow circle and those red warnings. I don't get those on mine.
Thank u bro!
greetins from peru South america
christian ramos Hi glad to meet you!
Thank you for your videos.
You're very welcome! Thanks for the comment and the "Likes"
Hi, thanks for video, i have a question though, how to have each loop to execute (for example) to 5 rows? I noted in each loop u only apply to one cell.
I super like these videos.. Thank you ExcelVbaIsFun!
Hi i want to is there any option that we can disable the complete sheet from manual printing only if we click on the button/shape it will print ?
Agree. This yellow circle is good when you watch the video in 120p :)
Thanks very much, that was really helpful :)
I'm so glad to hear it drmaxwell, you're very welcome! Dan
Starting a new channel for Piano Lessons, learn by Chord and play by ear! Check it out here: How to Play Piano by Chord - Beginning Chords - C
Hi Dan, thanks for your reply, I have a question, loops work fine if with a limited number of rows, if we have a big database of 20000 rows are more, and would like to count a specific number of times a variable occurs in database along with certain criteria which qualifies that variable in them same row, then place that count in a cell. can you help me with this. Murali
Another great video. Thanks
Thanks ermurali01!! Please let me know if you have any suggested video topics OR questions. Dan
Love you, love excel! Thanks!!!!
Alfred?
Ok, will work on a vid. sounds interesting. I assume you're talking about the background color of the cell, not the Font color, yes?
thx 4 ur efforts!
my pleasure, Nawar!
Hi , I had a quick question. Let say I have a which contains the names of clients. Each client has on average 4 rows. However, the name is written on only the first row of that client. What can I do to make empty cells automatically fill with the name of the last filled row in that column?
Fantastic and you're super welcome! And thanks!!!
What's your email notifier program's name?
hey im working on a persenal administration file ware i want to make a cel that starts black and if you click it it gets red if you click it again it getst green and if you click it one more time it gets to blank again and its in a list of cels that are clicble each seperate of eachother any help would be realy apriciate ty
Hello ExcelVbalsFun, I hope you are well. I have a question that I can not find the answer and I hope you can help. In your example "For x = 1 to 10". What if I wanted to be able to change the " 10 " element from the excel main sheet1. I am thinking like I would enter a value in a cell and the loop would run that many times. Or maybe a pull down or something. Any suggestions? Thank you
GREAT VIDEO
what would I do if I wanted to do root functions for the for and next functions?
Well met sir..and Well done..thank you.Instant subscriber=me!
Cool. Glad to have ya, jetpaq!!
Hello how can i use this code for xlookup thanks
i like your videos , and i learn .i am beginer of vba . so its benefit for me.
i face a problem on the chapter 3 ( for and next ) and loop . you have a any easy way to learn these chapter...
I have some issues here. I'm using Excel 2010 and following the procedure in this video to its exact detail, and I'm getting error message "Compile Error - Variable not defined". Am I missing something here?
How to insert formula for eg. =sum(A2:E2) or any vloopup formala
Hello everyone!
I have one question.
Why not showing (at the video) Dim x as Integer???
It is not properly.
Can explain me this situation...
Thank/
I believe the reason is the Option Explicit button ON or OFF. He has it OFF for now, which do not make it mandatory for the user to declare the variable and vice-versa. Hope that helps. :)
Hey !!! I am not able to get the excel VBA sample for this....please help.
Hi Mamoudou, I changed the link in the video description to excelvbaisfun.com/free-workbooks/
Thanks
Dan
what's the use of NEXT in your above code?
Oh Just one question. I don't like to use cell, I prefer to use range. So is it possible to use range instead of cell in the for and next ,? Because,I did try it but didn't work
thanks you for that ; I am so thankfull (yaya from Algeria)
Hi! I have a VBA question.
I have a bar graph showing the the number of sales every month for the last 5 months.
For example: 1000 in Oct, 1200 in Nov, 1300 in Dec, 950 in Jan, and 800 in Feb
The Months are in One row (Row A), the number of sales are in another row (Row B).
Next month, I want to show the number of sales for (Nov, Dec, Jan, Feb, March) on the graph. The month after, it would shift again (Dec, Jan, Feb, March, April) and so on
And then keep on repeating that as months go by (looping)
How would I code that loop on VBA?
I'm aware of the fact that I can manually change the range, but we are trying to automate the system so that there is no manual work needed (and this code will go in between many other codes that I already have)
Thanks for the help!
Every Month I need to copy a range of data from one workbook to another workbook. In the column are the Months (Starting from April 18 till May 21). In the source file the Months are in row 2 (starting from E2, F2, G2, etc.) In the active file the Months are in row 5 (from CJ4, CK4, CL4, etc. till DU4).When the Month is ended I need to copy a range of 27 cells (row 3 till row 29) from the source file into the active file the column is based on the selected Month in cell (CI2) from the active workbook. The range is always 27 cells.So in the active workbook, I first select a Month (e.g. Aug 18) and then I click on a button to activate the copy function.At the moment I used IF, and ElseIf functions but this is a very long code. Can you help me to program a combination of a Vlookup with a loop function or something. There must be a much easier way to do this than I do now...right?Active Workbook Source file
Hey ...I m interested in ur email notifier ... how do you do this ?
Hi Percy,
www.incredimail.com has this ability. I use gmail nowadays or Outlook though for better functionality.
Thanks
Dan
I wish VBA programmers would use indentation. It's not just to make it pretty. Indenting code properly is key to reading and understanding the function and flow of it
Agreed. It really causes headaches trying to figure out what's happening in a large loop with a gazillion embedded IF THEN statements. Thanks for the comment!! :)
Is that your private youtube channel? I'm really respect of you.
Can anyone say why this code doesn't work in Excel VBA 2003? Thanks
thank you for sharing sir.
Very welcome!!
when i write x = 1 i get an error complie error Variable not defined
He probably has x defined as a Public object, meaning he can use that object anywhere. He probably should have mentioned that.
To use x in this example you'd have to define it. Right under "Sub Test1()" put "Dim x as Integer"
@@Chimmahhable Many thanks for your answer!!
Thank you so much!
Do you have an email butler?
Whats the meaning of Sub
can you use variable in the way that the for is changing the variable it self?:
For k = 1 To 10
something & k = k
Next k
Well, this does not work - why?
many Thanks
Very welcome, Hazem!
its like a activation button that i can use to activate modules inside excel to count ore not to count i can send you a file ore we can skype if you want to give you a beter explenation the code is below
Yes, that's do-able, but a sample would make better sense. Can you make a sample workbook to share with me? I can use the sample data to respond and make a video. Cool.
Thanks a lot sir.....
Cool, thank you killingthecombover
If you're being forced to define your variable, you'll need to change your settings. It's EASY! Check out my video in my Basics Series. Video #17 is about that.The link is this, of course replacing dot with a period.
youtube dot com/watch?v=Egf02zq95s8
LIKE, THANKS BRUH!
lol what about that email notifier I need that one
You're very welcome, Mike. de nada
Nice tut, Thanks for you efforts. But there are too much "blah" in the video.
God bless you
Thanks
i'm still trying to understand why write VBA when you can create macros etc...
lots of love
Thanks, Sarat! Back at ya!
Sorry... your video os blurry on the iMac