The title said "Mastering Variables Like A Pro" but by the end of the video we learned much more than that: With statement, if statement, for next loop, printout. The example is just perfect for the practice. A really big 👍for the tutorial Randy. Thank you!
Thank you so very much, I really appreciate that. I try to pack in as much value as possible in these videos. I also have dedicated videos on If/Then statements and For/Next loops. Check out all of the basic VBA videos here: ua-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html I hope this helps and thanks so much.
Nice video. I included another variable to avoid manually typing in the last row, 6 in your case..... after Dim EmplRow As Long 'Whole Number Variable add the following Dim LastRow As Long LastRow = EmplSht.Cells(EmplSht.Rows.Count, "B").End(xlUp).Row And instead of 6 write "LastRow" With EmplSht For EmplRow = 3 To LastRow As the subject is variables, I thought this would fit...
HI and thanks, Yes for sure. I was about to do that as well, but I am really trying to keep these initial videos very basic. Thank you for your Likes, Shares & Comments. It really helps.
Yes for sure I will. Each and every weekend I will have a new video on VBA for Beginners. Thank you for your Likes, Shares & Comments. It really helps.
This is great. I love your approach. It is very easy for a beginner to actually follow through and learn, even without English being their first language. I can't quantify the value, please keep it up sir.
I have seen many people teaching excel. But none of them even close to your work. But if u add pdf explaining the logics used in the workbook separately it will be great. Also describe what is ur logical approach to a workbook
Thank you so very much, I really appreciate that and will do my best to add in logic and use as well. Thank you for your Likes, Shares & Comments. It really helps.
Randy, I love your instruction videos . I have been using VBA for quite some time. Is there a way to teach VBA from scratch. I usually use pre written code and change it. This class would be more reasoning behind writing code. For example start with a question than show the process and why of the code.
Hi and thanks, Yes for sure. As this series progresses, we will start with small problems and see how VBA can help us solve those problems. Once the fundamentals are taught in this series. I hope this helps and thanks so much.
Thank you so very much, I really appreciate that Alejandra. Much appreciated You can download your free Personal Macro Library for this link: bit.ly/PersonalMacro_WkbkDl Thank you for your Likes, Shares & Comments. It really helps.
HI and thanks. Perhaps it can be done in Access however I have not worked in Access in many, many years. Thank you for your Likes, Shares & Comments. It really helps.
Great Michael. thanks so much. I will be creating a basic VBA training each and every Saturday from now on. Thank you for your Likes, Shares & Comments. It really helps.
I am enjoying watching your series on basic subjects even though I probably know much of the content. But there are still tidbits to pick up. Please consider expanding on the variables issue to include variable scope... to include global, public, static etc. Scope is critical to writing many routines. Also an interesting advanced feature I learned about from Chip Pearson called Hidden Name Space that allows you to set a variable in one workbook, close it and open another workbook and retrieve it's value. Not really a scoping issue, but a way to pass variables. This works at the application level and as long as you keep your session open, the variables remain in context. I had an issue with 32 vs 64 bit routines that couldn't be solved with compile time directives (subject for another video perhaps ) and needed separate front ends for a common back end processing program and I created a master that called only the front end routine needed and the data became available from either of the front end programs. Anyway... enjoy all your presentations.
Hi Malcolm. Thanks so much for your feedback and ideas. Very helpful. I have written then down and will certainly consider them for topics in this series. Thanks again for your continued support and feedback.
Hi and thanks so much for your comment. There are many uses for macros. Please feel free to look over my channel. I hope this helps and thanks so much.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Muchas gracias por su comentario. Para ayudarlo a aprender cómo crear macros, asegúrese de ver mis videos de los sábados en los que cubro la programación básica de VBA aquí: ua-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html Espero que esto ayude y muchas gracias.
Sub Module() Dim EmplName As String, Work As String Dim PayDate As Date Dim PayAmt As Double Dim Paid As Boolean Dim EmplRow As Long EmplRow = 3 For EmplRow = 3 To 6 With Emplsheet EmplName = .Range("B" & EmplRow).Value 'Employees Name Work = .Range("C" & EmplRow).Value 'Work Completed PayDate = .Range("D" & EmplRow).Value 'Pay Date PayAmnt = .Range("E" & EmplRow).Value 'Pay Amount Paid = .Range("F" & EmplRow).Value 'Paid If Paid = False Then 'Not paid yet .Range("K2").Value = EmplName .Range("N2").Value = PayDate 'pay date .Range("K4").Value = Work 'Work Completed .Range("N4").Value = Paid 'Paid True/False .Range("f" & EmplRow).Value = True End If End With Next EmplRow End Sub Hi I am getting Error in "Paid = .Range("F" & EmplRow).Value 'Paid" this code and the error is "Type Mismatch" but i am not getting the mistake so please help me i tried a lot to find that mistake but i am not getting.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm
The title said "Mastering Variables Like A Pro" but by the end of the video we learned much more than that: With statement, if statement, for next loop, printout.
The example is just perfect for the practice. A really big 👍for the tutorial Randy. Thank you!
Thank you so very much, I really appreciate that. I try to pack in as much value as possible in these videos. I also have dedicated videos on If/Then statements and For/Next loops.
Check out all of the basic VBA videos here: ua-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
I hope this helps and thanks so much.
I discovered this channel a few weeks ago and I must say I am already a fan. And for now: starting the acadamy masterclass 💪
Wow Great. Welcome Aboard Jan. Great to have you and thanks so much for your support.
Nice video. I included another variable to avoid manually typing in the last row, 6 in your case.....
after Dim EmplRow As Long 'Whole Number Variable add the following
Dim LastRow As Long
LastRow = EmplSht.Cells(EmplSht.Rows.Count, "B").End(xlUp).Row
And instead of 6 write "LastRow"
With EmplSht
For EmplRow = 3 To LastRow
As the subject is variables, I thought this would fit...
HI and thanks, Yes for sure. I was about to do that as well, but I am really trying to keep these initial videos very basic. Thank you for your Likes, Shares & Comments. It really helps.
DIM is *Declared_In_Memory* regards from New Delhi 🇮🇳🇮🇳
Thanks so much :) Thank you for your Likes, Shares & Comments. It really helps.
Wow!! I can finally Understand Declaring Variables. Thank You Randy for Your hard work teaching us .
For sure, you are very welcome Michael, I am really happy I could help and share.
Wow, someone i can actually follow! Thank you. Yeah you are the best out there I think.
For sure, you are very welcome and thanks so much for your kind comment. I really appreciate that.
Clear language, understandable, educational and well explained. Thank you for this fourth lesson on Saturday.
Great, thanks so much. I am really happy to bring you this new series each weekend. Thank you for your Likes, Shares & Comments. It really helps.
please continue the beginner course
Yes for sure I will. Each and every weekend I will have a new video on VBA for Beginners. Thank you for your Likes, Shares & Comments. It really helps.
This is great. I love your approach. It is very easy for a beginner to actually follow through and learn, even without English being their first language. I can't quantify the value, please keep it up sir.
Thank you so very much, I really appreciate that and happy to help and share
It was an excellent use case to demo how variables and loops work. Loved it.
Great and thanks so much. Soon I will have a dedicated lesson on loops as well. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, I really understand from your videos, thank you sir
That is really great to hear and thanks so much for the feedback. Thank you for your Likes, Shares & Comments. It really helps.
Thanks a lot, Sir!!
Please keep sharing similar beginners' videos as your way of teaching is amazing.
Yes for sure I will, each and every Saturday. Thank you for your Likes, Shares & Comments. It really helps.
Thanks Randy for this amazing video.
Thank you so very much, I really appreciate that Syed
Thank you sir for your good effort to listen to us about vba for beginners.❤❤❤
For sure, you are very welcome and happy to help and share
Excel-lent tutorial ! Thanks Randy !!!
Thank you so very much, I really appreciate that Tony :)
I have seen many people teaching excel. But none of them even close to your work. But if u add pdf explaining the logics used in the workbook separately it will be great. Also describe what is ur logical approach to a workbook
Thank you so very much, I really appreciate that and will do my best to add in logic and use as well. Thank you for your Likes, Shares & Comments. It really helps.
Thank you. We are loving it!!!
Great and thanks so much. I am happy to help and share
Randy, I love your instruction videos . I have been using VBA for quite some time. Is there a way to teach VBA from scratch. I usually use pre written code and change it. This class would be more reasoning behind writing code. For example start with a question than show the process and why of the code.
Hi and thanks, Yes for sure. As this series progresses, we will start with small problems and see how VBA can help us solve those problems. Once the fundamentals are taught in this series. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you
Excellent tutorial. Thanks a lot!
Thank you so very much, I really appreciate that Christopher
Brilliant. Tons of info in such a short amount of time. Thank you for this
Great, thanks so much and I am happy to help and share
Randy is the Bomb! Thank you for sharing your knowledge and expertise.
For sure, you are very welcome and I am very happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
Excellent!!!
Thank you so very much, I really appreciate that Alejandra. Much appreciated
You can download your free Personal Macro Library for this link: bit.ly/PersonalMacro_WkbkDl
Thank you for your Likes, Shares & Comments. It really helps.
Wonderful Sir. Can it be done in Access
HI and thanks. Perhaps it can be done in Access however I have not worked in Access in many, many years.
Thank you for your Likes, Shares & Comments. It really helps.
Thanx man ...
You are great ...
Thank you so very much, I really appreciate that
Very helpful. Please continue the VBA Videos
For sure, you are very welcome and thanks. I will for sure keep it up. Much appreciated
Awesome, enjoyed this simple variable lesson, thanks Randy.
Great Michael. thanks so much. I will be creating a basic VBA training each and every Saturday from now on. Thank you for your Likes, Shares & Comments. It really helps.
Thank you
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
Thanks, Randy. I used some VBA, but nothing as clever as that. I can already see a project...
For sure, you are very welcome I am happy to help and share
Very nice video ! Thank you very much
For sure, you are very welcome and happy to help and share
Brilliant 👏 👏 👏
Thank you so very much, I really appreciate that
May I confirm that the commend "EmplRow=3' is for nofity VBA that the process is for Row 3? Thanks. By the way the lecture is awesome!
Hi and thanks very much. Yes that is correct, that means we are assigning 3 to the EmplRow variable. I hope this helps and thanks so much.
I am enjoying watching your series on basic subjects even though I probably know much of the content. But there are still tidbits to pick up. Please consider expanding on the variables issue to include variable scope... to include global, public, static etc. Scope is critical to writing many routines. Also an interesting advanced feature I learned about from Chip Pearson called Hidden Name Space that allows you to set a variable in one workbook, close it and open another workbook and retrieve it's value. Not really a scoping issue, but a way to pass variables. This works at the application level and as long as you keep your session open, the variables remain in context. I had an issue with 32 vs 64 bit routines that couldn't be solved with compile time directives (subject for another video perhaps ) and needed separate front ends for a common back end processing program and I created a master that called only the front end routine needed and the data became available from either of the front end programs. Anyway... enjoy all your presentations.
Hi Malcolm. Thanks so much for your feedback and ideas. Very helpful. I have written then down and will certainly consider them for topics in this series. Thanks again for your continued support and feedback.
Thank you for your help
For sure, you are very welcome and thank you for your Likes, Shares & Comments. It really helps.
Thank you.
For sure, you are very welcome and thanks so much
Please teach Arrays i always face trouble with Array. Thanks regards
Thanks so much. For sure we are going to get into arrays in the very near future. Much appreciated.
@@ExcelForFreelancers thank you Sir
excellent
Thank you so very much, I really appreciate that
I am in love with you for what you are doing.❤❤❤❤
Thank you so much for your kind words! It means a lot to me that you appreciate what I do.
Hi sir , i have a doubt , can we do this using vlookup ?, if we can do this using vlookup then what is the use of using macro
Hi and thanks so much for your comment. There are many uses for macros. Please feel free to look over my channel. I hope this helps and thanks so much.
1st first viewer I'm so glad 😊
Thank you so much for being the first viewer! Your support means the world to me.
Hello teacher I help modules not running
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
soy chingon copiando pero cuando quiero hacer una macro para mi trabajo no la hago
Muchas gracias por su comentario. Para ayudarlo a aprender cómo crear macros, asegúrese de ver mis videos de los sábados en los que cubro la programación básica de VBA aquí: ua-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
Espero que esto ayude y muchas gracias.
You look like a shaolin monk
Hahaha, sometimes I feel like one. Thank you for your Likes, Shares & Comments. It really helps.
Sub Module()
Dim EmplName As String, Work As String
Dim PayDate As Date
Dim PayAmt As Double
Dim Paid As Boolean
Dim EmplRow As Long
EmplRow = 3
For EmplRow = 3 To 6
With Emplsheet
EmplName = .Range("B" & EmplRow).Value 'Employees Name
Work = .Range("C" & EmplRow).Value 'Work Completed
PayDate = .Range("D" & EmplRow).Value 'Pay Date
PayAmnt = .Range("E" & EmplRow).Value 'Pay Amount
Paid = .Range("F" & EmplRow).Value 'Paid
If Paid = False Then 'Not paid yet
.Range("K2").Value = EmplName
.Range("N2").Value = PayDate 'pay date
.Range("K4").Value = Work 'Work Completed
.Range("N4").Value = Paid 'Paid True/False
.Range("f" & EmplRow).Value = True
End If
End With
Next EmplRow
End Sub
Hi I am getting Error in "Paid = .Range("F" & EmplRow).Value 'Paid" this code and the error is "Type Mismatch" but i am not getting the mistake so please help me i tried a lot to find that mistake but i am not getting.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.