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
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
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
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!
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!!!
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
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.
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!
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 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
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
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?
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.
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.
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?
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
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
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!
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...
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"
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. :)
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
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?
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 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!! :)
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.
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
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
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
Thanks Daniel for taking your time in making this video. God bless you greatly.
Its 2019 and this tutorial is still relevant.
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!
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!!!
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
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!
Thank God, I found this channel. So blessed to have someone like you teaching us vba for free. God bless Sir
Amazing series of VBA Basic videos! Thanks, ExcelVbaIsFun!!
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!!
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!
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
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!
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
These videos are great. Please keep them coming. Do you have any videos focussed on importing stock data (more than just the price)?
Thanks for helping with these amazing tutorials!
You're absolutely welcome!
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, you are great I can learn it easy for 3 lesson already! Thanks from Cambodia
Alfred?
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
very informative and a learned a lot, looking for more videos
Thanks Dan, where is that do while loop example? :)
Thanks a lot, You explain it very easy. Greets from Germany
You're very welcome, Kai! thanks for the kind words!
How do you get the yellow circle and those red warnings. I don't get those on mine.
Excellent! vid tutorial Dan; & very interesting.
I am learning a lot; in VBA basics.
Thank u 4 sharing.
thank you. very informative and easily explained
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 ?
Hey superb videos.... I learnt alot from them.
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
Thanks very much for these great videos.
Very welcome!
What's your email notifier program's name?
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
Thank you. for some great stuff. You explained everything very nicely.
Thanks ermurali01!! Please let me know if you have any suggested video topics OR questions. Dan
thanks for this great tutorial!
You're very welcome, marvin!
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?
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 how can i use this code for xlookup thanks
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?
?? 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
Thank you so much, your videos are so helpful^^
Thanks for the videos Dan!
what's the use of NEXT in your above code?
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.
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
what would I do if I wanted to do root functions for the for and next functions?
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?
I super like these videos.. Thank you ExcelVbaIsFun!
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
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'm so glad to hear it drmaxwell, you're very welcome! Dan
Agree. This yellow circle is good when you watch the video in 120p :)
Thank you for your videos.
You're very welcome! Thanks for the comment and the "Likes"
Another great video. Thanks
Super teaching sir
How to do data entry using vba? How to enter coloum headers n rows in vba?
How to insert formula for eg. =sum(A2:E2) or any vloopup formala
Love you, love excel! Thanks!!!!
Thanks very much, that was really helpful :)
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
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
Thank u bro!
greetins from peru South america
christian ramos Hi glad to meet you!
Whats the meaning of Sub
Do you have an email butler?
thx 4 ur efforts!
my pleasure, Nawar!
Can anyone say why this code doesn't work in Excel VBA 2003? Thanks
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!
GREAT VIDEO
Fantastic and you're super welcome! And 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...
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
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!!
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. :)
Is that your private youtube channel? I'm really respect of you.
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
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
thank you for sharing sir.
Very welcome!!
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?
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
Well met sir..and Well done..thank you.Instant subscriber=me!
Cool. Glad to have ya, jetpaq!!
many Thanks
Very welcome, Hazem!
You're very welcome, Mike. de nada
Thank you so much!
thanks you for that ; I am so thankfull (yaya from Algeria)
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!! :)
Cool, thank you killingthecombover
Sorry... your video os blurry on the iMac
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.
i'm still trying to understand why write VBA when you can create macros etc...
lots of love
Thanks, Sarat! Back at ya!
lol what about that email notifier I need that one
Thanks
Thanks a lot sir.....
LIKE, THANKS BRUH!
Nice tut, Thanks for you efforts. But there are too much "blah" in the video.
God bless you