MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_Gyp9_mISug4 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
I'm very glad to be able to help :) I'm also now making a MUCH larger Macros course that will be on teachexcel.com in.... well I don't know when but I hope in 1 or 2 months hah - if you signup for the newsletter there you will be notified when it's released.
Amazing. Completed the first 2 tutorials in one sitting. Had to pause the tutorial occasionally to try out the steps, but it was worth it. Too late at night to continue, so will continue tmrw. Tks so much
Thank you for your detailed tutorial and your laid-back approach. It was excellent and easy to understand when somebody like yourself teachers VBA/Macros. Keep up the good work.
I consider myself very skilled with excel, but complete shite when it comes to VBA. These videos are of great help to me and my ambitious modeling endeavours. You rock dude, thanks for keeping us smart during quarantine 😄
Hey mate - I just want to say your videos are amazing. I'm currently working as an Accountant but took an interest in learning Excel coding just a month ago. I'm hoping when I get to the more advanced levels I can incorporate macro knowledge into my work. Also, how long does it take to get very proficient with macros?
Excellent explanation. I did it step by step but it is showing me this error when run: "can't execute code in break mode". Can someone help me to correct the error? Thank you
Sir I am learning Macro in this lesson, when I press Run button, it shows that Variable not defined and abcValue = is highlighted so how to short out this problem?. I download che che sheet and that works fine so so what to do? I am using Office 365 Microsoft Excel 2019.
Hello sir Please Can you teach ..cell changing its value every 1 mins need to be remembered and it should dilever average or sum .. in (other) but specific cell in every 5 mins and keep on offset 1 cell
Sir how about if the cell is a variable? lets say... range("A1") to range("A10"). i want to change 1 to 10 into variable. range("A(variable)"). if variable = 2 then range("A2") will activate. thanks in advance.
Yes! (sorry for late reply) If you would like help creating such a macro, ask on our forum - we won't do it from scratch for you, but we will happily help you along the way :) www.teachexcel.com/talk/microsoft-office?src=yt
Dear friend, I hope you could help me to create an excel sheet that helps me in my job as a Claims Assessor in an Insurance industry. We don’t have good system at the moment to monitor and follow up each claim and we are doing it manually setting up a reminder or printing a lot of papers. Having hundreds of claims submitted each month and you need to track them one by one when you need them to follow up create too much time. I need an excel sheet that you can change or move the dates into future or backward then it will automatically hide in my current task so I can focus only to task assigned to present date. Just clicking a button to move the dates for each claim. And When the task that was moved reach the day you set, it will show only the claims that you set for present. The column which normally needed: 1. No. (1,2,3,....) 2. Claim number (divided into reimbursement, direct billing, and pre-authorization) 3. Name of patient 4. Date of birth ( automatically calculate the age) 5. Member ID: 6. Hospital name 7. Diagnosis 8. Country/location 9. Date of service 10. Claim received date 11. Claims status (open, close, decline, re-open) 12. Pending or to do task ( that I can write a note then move the dates anytime to follow up. I do appreciate your help! Best regards, JR Email: Blanco_jarr@yahoo.com
When I follow the exact steps laid out up until time 7:46 of the video, Excel won't run the macro due to the comment "Can't execute code in break mode"
If you press F5 or select the Square button (Stop), visible in his video just under "run" at the top, it will remove that break. The break usually happens because there was an error or you are running the "Debug". If you have an error in your code, you will have to fix that before being able to move on. Hope this helps.
MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_Gyp9_mISug4
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
EXCELLENT SERIES OF CLASSES! Was banging my head against the wall until I found these classes. I was blind, but now I see.
Who's learning during lockdown to enhance their skills? :) Brilliant tutorials thus far btw, thanks a lot!
I'm very glad to be able to help :) I'm also now making a MUCH larger Macros course that will be on teachexcel.com in.... well I don't know when but I hope in 1 or 2 months hah - if you signup for the newsletter there you will be notified when it's released.
TeachExcel Fantastic! Thank you 😊
@@TeachExcel please do share some of your macros to me on subramanya03.r@gmail.com
I loved your tutorials
Beautiful world me truly
@@TeachExcel Is that new course going to be on youtube? There isn't much VBA on youtube compared to other languages.
Amazing. Completed the first 2 tutorials in one sitting. Had to pause the tutorial occasionally to try out the steps, but it was worth it. Too late at night to continue, so will continue tmrw. Tks so much
Thank you so much. I have been avoiding this subject for 20 yrs. I am finally going to learn Macros :)
Thank you for your detailed tutorial and your laid-back approach. It was excellent and easy to understand when somebody like yourself teachers VBA/Macros. Keep up the good work.
Your explanations are very clear, understandable and followable. You'd be a good teacher.
OMG, your class is so helpful. you have no idea how much I want to thank you. very clear explanation. love it....
I consider myself very skilled with excel, but complete shite when it comes to VBA. These videos are of great help to me and my ambitious modeling endeavours. You rock dude, thanks for keeping us smart during quarantine 😄
Thank you. Easy, Simple, Understandable.🙏🙏
Enjoyed your toturial so much. It's easy to follow for a absolute beginner, thank you!
Really good tutorial. Your voice is nice to listen to. Thanks!
Thanks!)
You are a fantastic instructor.
This is so awesome, I cannot wait to try this out and practice this! 🎓
:)
Nice explanation, Very easy understand lay man language.
Superb great ideas your are sharing easy to learn VBA
That was an excellent tutorial! Thank you so much!
You are very welcome! Thank you for your kind words! I'm working on the premium course right now and that will be even better than this :)
Understand all clearly once done
what an awesome teacher you are :)
thank you for putting this online. very helpful.
super easy and awesome sir!
Excellent stuff and a crisp presentation which is very easy to follow
Hey mate - I just want to say your videos are amazing. I'm currently working as an Accountant but took an interest in learning Excel coding just a month ago. I'm hoping when I get to the more advanced levels I can incorporate macro knowledge into my work. Also, how long does it take to get very proficient with macros?
awesome tutorial! thanks for the help and free content!
VERY EASY AND INFORMATIVE VIDEO FOR BEGINNERS. HOWEVER I AM NOT DOWNLOAD A FILE OF THIS VIDEO. COULD ANYONE TELL ME PLEASE...
Excellent explanation. I did it step by step but it is showing me this error when run: "can't execute code in break mode". Can someone help me to correct the error? Thank you
You Are awesome.
amazingly explained.
Awesome tutorial, thankyou
You're welcome)
Sir I am learning Macro in this lesson, when I press Run button, it shows that Variable not defined and abcValue = is highlighted so how to short out this problem?. I download che che sheet and that works fine so so what to do? I am using Office 365 Microsoft Excel 2019.
Amazing!
Hello sir
Please Can you teach
..cell changing its value every 1 mins need to be remembered and it should dilever average or sum .. in (other) but specific cell in every 5 mins and keep on offset 1 cell
Thanks bro
great tutorial
Very informative lesson...thank you!!
I am not able to access the files from above link.
Sir how about if the cell is a variable? lets say... range("A1") to range("A10"). i want to change 1 to 10 into variable. range("A(variable)"). if variable = 2 then range("A2") will activate. thanks in advance.
1-2 Exellent Tutorial
Very helpful.. Thank you so much :)
how do you refer to the hyperlink off a cell?
Excellent. Thanks.
Thank you sir.. you are simply amazing...i wish if I could get your direct contact so that I could clear my doubts.
Just ask on our forum, it's free :) www.teachexcel.com/talk/microsoft-office?src=yt
Can we consolidate excel files by macros from a folder
Yes! (sorry for late reply) If you would like help creating such a macro, ask on our forum - we won't do it from scratch for you, but we will happily help you along the way :) www.teachexcel.com/talk/microsoft-office?src=yt
great job!
Great stuff! Thanks :-)
How to get a list of names of two 2 workbooks by clicking a button
Tnx
Thanks!
Best of the best
Dear friend,
I hope you could help me to create an excel sheet that helps me in my job as a Claims Assessor in an Insurance industry. We don’t have good system at the moment to monitor and follow up each claim and we are doing it manually setting up a reminder or printing a lot of papers. Having hundreds of claims submitted each month and you need to track them one by one when you need them to follow up create too much time.
I need an excel sheet that you can change or move the dates into future or backward then it will automatically hide in my current task so I can focus only to task assigned to present date. Just clicking a button to move the dates for each claim. And When the task that was moved reach the day you set, it will show only the claims that you set for present.
The column which normally needed:
1. No. (1,2,3,....)
2. Claim number (divided into reimbursement, direct billing, and pre-authorization)
3. Name of patient
4. Date of birth ( automatically calculate the age)
5. Member ID:
6. Hospital name
7. Diagnosis
8. Country/location
9. Date of service
10. Claim received date
11. Claims status (open, close, decline, re-open)
12. Pending or to do task ( that I can write a note then move the dates anytime to follow up.
I do appreciate your help!
Best regards,
JR
Email: Blanco_jarr@yahoo.com
is ur job done?
Madhanmohan Reddy actually not yet. I’m looking for someone could help me
As the default property for cells is value, there should be no reason to use .value in your code.
Thanks
Accidentally wrote:
Sheets("sheet1").Range("E6").Value = Sheets("Sheet2").Range("A2").Value = Sheets("Sheet2").Range("A2").Value
And kept getting TRUE, got to watch for duplication.
I want to make a macro which will work for 1000 data items
Thx
Any suggestions?
What threw me off was the abcValue. I had to watch the vid 3 times before I could figure it out.
When I follow the exact steps laid out up until time 7:46 of the video, Excel won't run the macro due to the comment "Can't execute code in break mode"
If you press F5 or select the Square button (Stop), visible in his video just under "run" at the top, it will remove that break. The break usually happens because there was an error or you are running the "Debug". If you have an error in your code, you will have to fix that before being able to move on. Hope this helps.
thanks
You're welcome)
"Bam" -TeachExcel 2018