This is a series that I am waiting for. Because most of the videos I downloaded is too technical for my understanding. Please from scratch would be appreciated. If you have done one in the past please send a link. Much love❤
Yes Emmanuel. To be honest, I felt that so many people had basic VBA videos so there was no need. However, my followers asked so much for me to create the series, so I am really happy to bring it to you. I also have a 'from scratch' video coming out next Tuesday right here: th-cam.com/video/e7tUsgWh3Uw/w-d-xo.htmlsi=pZ3s4xD33kgUs3D1 Thank you for your Likes, Shares & Comments. It really helps.
I recommend this video from a beginner standpoint (which I am)..this is my first learning video that I a have finished without hoping to some other distractions.🙌
I am new here!! Although I don't usually comment on videos, this channel is by far has the most in depth tutorials that are taught beautifully. Thank you very much!!
Thanks Randy!!!! :) :) This is something that I always wanted.......starting from scratch. I do not know any VBA, so this will help. Thanks again!!! :) :)
Thank you so very much, I really appreciate that Tammy. Make sure to catch the 2nd video in the series coming this Saturday. Thank you for your Likes, Shares & Comments. It really helps.
Thank you so very much, I really appreciate that. You can find all of the new videos for VBA Basics on this playlist th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html I hope this helps and thanks so much.
Really looking forward to this series and I like your other videos. I was wondering what differences there may be if using Excel for Mac. I know there are difference with things like power query and others. Thank you! Mark
Hi and thanks. Mac's are limited with Excel & VBA, so if I had a choice, I would go to with Windows. You can find more information on Excel VBA for Mac here: www.macexcel.com/ I hope this helps and thanks so much.
Hi and thanks so much. Yes I will continue this each and every Saturday. I will also continue intermediate to advanced every Tuesday as well. Thank you for your Likes, Shares & Comments. It really helps.
Thank you so very much, I really appreciate that Neren. These trainings are probably well below your skill level, but a lot of people have requested these trainings. Of course I will stil be doing the intermediate to advanced every Tuesday. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy ... I am not advanced 😢 Saldy even watching lots of tutorials, it's the way it is presented. I was hooked on your training years ago because of the layout and format and still love them to this day. This training, people need to know what is possible using VBA. Thanks Randy
Thank you so very much, I really appreciate that. I am really glad you enjoyed this. Each weekend will be a new one. Thank you for your Likes, Shares & Comments. It really helps.
Super. Desde cero. Super Saturday 4 me. Now I will have the best of advanced and the best teacher from start... tks so much. Espero seguir creando mis programas de trabajo en Vba
HI and thanks so much. On all of my videos in the last few years I am using Office 365, however you can use any version you like, as my trainings can apply to any version in the last 20 years. I hope this helps and thanks so much.
Hi and thanks, yes for sure I will be creating a video on basic userforms in the near future in this VBA Basic series I hope this helps and thanks so much.
Thank you so very much, I really appreciate that. Variables are great when you want to reuse, or keep track of data. Variables are also a visual way to remember the data stored inside the variable. Since you commented on my training on 'Mastering Variables' that just came out, you saw that one already. So that training is focussed on just variables. I hope this helps and thanks so much.
Thank you so very much, I really appreciate that and look forward to having you. Much appreciated (Just a little hint, we have a great Black Friday promotion coming in 10 days) I hope this helps and thanks so much.
Hi and thanks so much. This course is from Daniel Strong. He was my mentor in VBA and I since he has such a great beginners VBA course I have partnered with him on this to help share his course. I hope this helps and thanks so much.
Hi and thanks very much Option Explicit, means that you are required to declare all variables in your code. In the VBA Editor Tools > Options > check the 'Require Variable Declaration' option, then any new module you add will have this Option Explicit text already at the top. I hope this helps and thanks so much.
@@ExcelForFreelancers thanks for the explanation. I am really liking the beginner series and learning a lot in the process. It's the best of all the ones I have tried so far.
Very interesting initiative to master the world of Macro and VBA files online. I would find it even more useful if the downloadable template also included a "Word or PDF file". Learning purely from the video is too fast for me to really let it sink in. But it's just a suggestion. Thank you very much for this first lesson.
Thank you so very much, I really appreciate that Ara. I will always make the Excel file available for download and will consider a PDF as well. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks very much. Yes sure this can be done. Please search my channel for 'Schedule' as I do this in many videos. I hope this helps and thanks so much.
Do you offer excel classes starting from square one all the way up to advance? Meaning if I just started using excel and I don’t know how to do anything aside from loading the sheet up and want to learn everything. Do you offer those types of classes as well?
Hi and thanks. Yes for sure. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared Also, in my Mentorship Program, which is on sale this month, I show you how to define, design, develop and deploy your Excel-based applications for passive income while I create a comprehensive accounting application in my Mentorship Program. You can learn more about this incredible course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
Hola Randy, emocionado de conocer vba, me sorprende lo que haces y espero que pueda lograrlo con las tutorias que impartirás, saludos y a la espera de de los tutoriales...
Perfect explanation!….but am not able to save vba project every time I reopen the code is missing and I have to rewrite it . While saving its showing “The following features cannot be saved in macro-free workbook" warning dialog” then clicked save yet it’s not working please provide me with a solution
Hi and thanks for your comment. The file must be saved as an ".xlsm" file to preserver the macros and not an xlsx file type. I hope this helps and thanks so much.
Where can I ask questions about the programs currently sold on the website? I am wondering if the excel mentorship mastermind is also for beginners who only know the most basic VBA.
Hi and thanks so much. I have a single course that is for beginners and it is from Daniel Strong, called the Ultimate VBA Course and you can find it here: bit.ly/VBACourseRandyShared I also have this on sale for 50% off for Black Friday. I hope this helps and thanks so much.
Hi and thanks so much Raymond. Yes, correct. Tuesday's will still be intermediate to advanced trainings were we will amazing applications in Excel. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks, it means that Variables are required to be declared. We will go over that specifically next weekend. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks very much. You can follow this playlist which will always have all of the Basic VBA Training, in order: th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html I hope this helps and thanks so much.
Great video Please make a tutorials video how to connect excel to msword, powerpoint, visio etc(define object as to open application and execute macro in orher application like ms word powerpoint visio etc
Hi, very interesting videos indeed... I made years ago vba files with a calendar in userforms. This ocx cannot be added in new excel versions and doesn't exist anymore in new excel. I've found an userform in internet that do the same work. But is it possible to insert an userform in an userform ? Do you know other solutions ? Thanks for your videos very useful...
Hi and thanks, yes sure its certainly possible. Le'ts assume you have a userform with a date field and you want a date picker to pop up, you can have this. Just set the Show Modal to False on the first userform which will allow the 2nd to be shown. I hope this helps and thanks so much.
If i download Excel have codes how to see those codes and data i have an excel sheet with codes and i wants to develop and make new things but i I need some of those codes inside it i tried many ways to see but not succeed ?
Kindly sir Make a Video for "Stationery Shop" like The Video Of "COFEE SHOP POS". please sir it's a request to you that makes a video on POS with Sales report and Inventory Management system fully Automatic for A Stationery Shop please.
Hi and thanks so much. You are welcome to download and customize the Coffee Shop POS for stationary. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
HI and thanks so much. I also just realized that Bitly link shortener is having an issue. Please feel free to download your workbook with the following link and thanks for your patience www.dropbox.com/scl/fi/skc8b1oqa1mq6gtm51sf4/Getting_Started_With_VBA.xlsm?rlkey=8omdbocrt72e6cmis3g36iz1o&dl=1
Yes absolutely important. I go over the 'Why' in this video. I also have a video on how to create an application with ChatGPT here: th-cam.com/video/0hF6zR7APUs/w-d-xo.html I hope this helps and thanks so much.
Hello, is there a way to hide tabs when I hide a tab then I get a VBA error. for example. I have a calculations tab and when I hide it. and run my macro the error is for the calculation sheet. I want others to use on my job but don't want them to see certain tabs. Thanks
HI and thanks very much. You should be able to calculate a hidden sheet. The only thing you cannot do i select a cell in a hidden sheet. 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.
Hi and thanks. I have checked all of the links and they seem to be working fine. You may have a firewall or some protection preventing you to reach the destination. You may want to try from another location or computer
Can you help me resolve an issue? I got the free workbook in my email but Bitdefender tried to block the link because it said it was an untrusted webpage. Also, after I downloaded the workbook, Excel has a red bar at the top and says Microsoft has blocked the macros because the source of the file is untrusted. Excel won't even let me mark the file as trusted. Any ideas?
Hi and thanks very much. I can assure you it is safe as I have programmed it myself. Bitdefender get's a log of things wrong. Concerning the red bar, as an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
Hi and thanks. I am very happy to help. I will be creating these tutorials each and every Saturday. It will be great to have you join us. Thank you for your Likes, Shares & Comments. It really helps.
Just FYI - It's very difficult to be a Mac user for Office. I have to use my old Macs to create dialog boxes. Really?? Does MS not realize Mac users are customers, a.k.a. a source of money?????
![ILLSLICK X YOUNGOHM - We're The same [Official Video]](http://i.ytimg.com/vi/yUJNkobYR0E/mqdefault.jpg)
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
The best Excel learning Channel. Thanks for all the Staff
Thanks so very much. I really appreciate that
Thanks, Randy, for this wonderful series. I have been waiting for it forever. Your efforts are much appreciated.
Thank you so very much, I really appreciate that. I am glad to help and share.
Thank you, Mr. Randy. What you are done is remarkable. I appreciate you.
Thank you so very much, I really appreciate that and your continued support
This is a series that I am waiting for. Because most of the videos I downloaded is too technical for my understanding. Please from scratch would be appreciated. If you have done one in the past please send a link. Much love❤
Yes Emmanuel. To be honest, I felt that so many people had basic VBA videos so there was no need. However, my followers asked so much for me to create the series, so I am really happy to bring it to you.
I also have a 'from scratch' video coming out next Tuesday right here:
th-cam.com/video/e7tUsgWh3Uw/w-d-xo.htmlsi=pZ3s4xD33kgUs3D1
Thank you for your Likes, Shares & Comments. It really helps.
All thumbs up to the greatest VBA youtube teacher. Thanks a lot Randy for all your hard work. Hope people subscribe as i already did 🙏
Thank you so very much, I really appreciate that Jojo. Very kind of you.
I recommend this video from a beginner standpoint (which I am)..this is my first learning video that I a have finished without hoping to some other distractions.🙌
WOW that is really Excellent. I am very happy to hear that. Thank you for your Likes, Shares & Comments. It really helps.
DIm: Declare in memory..that is going to stick for sure👌Thank you for these incredible videos...
Excellent. I am really glad I could help. Thanks again for your continued support.
thanks sir,
am waiting for your whole series, hopefully this will be a great journey .
thanks for this pertinent work.
Thank you so very much, I really appreciate that and I am happy to help and share
Thank you for starting this series. You do a wonderful job.
For sure, you are very welcome and so happy to help and share
Thanks Mr.Randy for your lessons. I like and begin to learn. You are super.
Thanks so much. I am glad I can help and share
I am new here!! Although I don't usually comment on videos, this channel is by far has the most in depth tutorials that are taught beautifully. Thank you very much!!
Thank you so very much, I really appreciate that and so great to have you here
I am struggling from many days in VBA For this new series i am so thankfull to you ❣❣
For sure, you are very welcome and happy to help and share
This lesson is great. I look forward to future lessons like this. You made VBA as easy as ABC.
Thank so much. Yes every Saturday I will be sharing new VBA For Beginner trainings. Thank you for your Likes, Shares & Comments. It really helps.
Thanks Randy!!!! :) :) This is something that I always wanted.......starting from scratch. I do not know any VBA, so this will help. Thanks again!!! :) :)
For sure, you are very welcome and so glad I could help
Thanks Alot mr.Randy we are so Happy with your support
And we started learning❤
That is so great. I am happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
My hero. Thank you, Randy & Team.
~Tammy
NC
Thank you so very much, I really appreciate that Tammy. Make sure to catch the 2nd video in the series coming this Saturday. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers ♥️♥️
Love this series, sir. Hope this series will be fruitful for me and other newbies like me.Thanks once again for this series.
Thank you so very much, I really appreciate that. You can find all of the new videos for VBA Basics on this playlist th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
I hope this helps and thanks so much.
I love this. Thank you.
That is great thanks so very much
Thank you very much Randy. This lesson was helpful.
For sure, you are very welcome and happy to help and share
Thank you very much for this new Series, you always share your knowledge with others and it is very valuable
Thank you so much for your kind words! I'm glad you find the new series valuable. I always strive to share my knowledge and help others.
Really looking forward to this series and I like your other videos. I was wondering what differences there may be if using Excel for Mac. I know there are difference with things like power query and others. Thank you! Mark
Hi and thanks. Mac's are limited with Excel & VBA, so if I had a choice, I would go to with Windows. You can find more information on Excel VBA for Mac here: www.macexcel.com/
I hope this helps and thanks so much.
Hi Randy. Can you share the link to Daniel Strong's VBA course? Thanks.
Hi sure you can learn more here: bit.ly/VBACourseYTDesc
Thanks so much
This lesson was brilliant. You've really explained these basic concepts very well. Thank you so much.
Great, thanks so very much. I am happy to help and share
Excellent Video. I would appreciate it if you continue this tutorial and make it up to the intermediary level as a series tutorial.
Hi and thanks so much. Yes I will continue this each and every Saturday. I will also continue intermediate to advanced every Tuesday as well. Thank you for your Likes, Shares & Comments. It really helps.
This is great, I hope to learn for your more advanced courses
Thank you so very much, I really appreciate that
Thanks sir your videos are very helpful.
For sure, you are very welcome and thanks so much. I am happy to help and sharer
Informative video and explained in lucid manner.👍
Thank you so very much, I really appreciate that
Great stuff!
Thank you so very much, I really appreciate that Hillary
Ive never used VBA in excel. Mostly used for accounting purposes. This will be interesting.
Great, thanks so much. I am glad you liked it
Hi Randy .. thanks for this and I am sure this is for everyone who wants to become more productive and efficient. Thank you.
Thank you so very much, I really appreciate that Neren. These trainings are probably well below your skill level, but a lot of people have requested these trainings. Of course I will stil be doing the intermediate to advanced every Tuesday. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy ... I am not advanced 😢 Saldy even watching lots of tutorials, it's the way it is presented. I was hooked on your training years ago because of the layout and format and still love them to this day. This training, people need to know what is possible using VBA. Thanks Randy
Awesome Neren. Thanks so much for your continued support.
Thanks Randy for this video.
For sure, you are very welcome Syed. I am happy to help and share
tthanks alot for this great great lesson. looking forward the next one
Thank you so very much, I really appreciate that. I am really glad you enjoyed this. Each weekend will be a new one. Thank you for your Likes, Shares & Comments. It really helps.
Super. Desde cero. Super Saturday 4 me. Now I will have the best of advanced and the best teacher from start... tks so much. Espero seguir creando mis programas de trabajo en Vba
Thanks so very much. I am really happy to bring this new series to you each and every weekend
thanks for everything.. great.. I love it
...from Iraq....
Thanks so much. I am glad to help and share.
Recently I start following you and find your channel very informative. I have a question that which version of office your using?
HI and thanks so much. On all of my videos in the last few years I am using Office 365, however you can use any version you like, as my trainings can apply to any version in the last 20 years. I hope this helps and thanks so much.
Cool video! Keep it up! 👍👍 even though my laptop is struggling while i am learning vba
Thanks so much. I am happy to help and share
More than great .if you please, need more videos VBA and User formsvv
Hi and thanks, yes for sure I will be creating a video on basic userforms in the near future in this VBA Basic series
I hope this helps and thanks so much.
Thank you randy. This is what I waiting and find.
That is great. So glad I could help.
Thanks a lot Randy.
For sure, you are very welcome and happy to help and share
Beyond excellent tutorial. How do we know when to declare a variable?
Thank you so very much, I really appreciate that. Variables are great when you want to reuse, or keep track of data. Variables are also a visual way to remember the data stored inside the variable. Since you commented on my training on 'Mastering Variables' that just came out, you saw that one already. So that training is focussed on just variables.
I hope this helps and thanks so much.
Thanks so much. Appreciate your work
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
Brilliant Sir. Thank you
Thank you so very much, I really appreciate that
Waiting for this series so long, and am really excited , as well as will be soon in ur ultimate vba course just have some issues these days ❤❤❤
Thank you so very much, I really appreciate that and look forward to having you. Much appreciated (Just a little hint, we have a great Black Friday promotion coming in 10 days)
I hope this helps and thanks so much.
@@ExcelForFreelancers Is the ultimate vba your course? I saw the sales page saying Dan. But I remember you name is Randy?
Hi and thanks so much. This course is from Daniel Strong. He was my mentor in VBA and I since he has such a great beginners VBA course I have partnered with him on this to help share his course. I hope this helps and thanks so much.
Thanks so much excel for freelancer
For sure, you are very welcome and thanks
Hello Randy, how are you? i thanful to you to create this VBA series. I really need of this.
For sure, you are very welcome and thanks for your feedback
Wow! 😲🔥
Short and concise and crafted with great care for beginners!!
Thanks for the hard work and dedication Mr Randy!!
My pleasure, and so glad you enjoyed it. Thank you for your Likes, Shares & Comments. It really helps.
When creating the first macro, what does Option explicit mean and must I type it in before typing the code for the macro? 12:05
Hi and thanks very much Option Explicit, means that you are required to declare all variables in your code. In the VBA Editor Tools > Options > check the 'Require Variable Declaration' option, then any new module you add will have this Option Explicit text already at the top.
I hope this helps and thanks so much.
@@ExcelForFreelancers thanks for the explanation. I am really liking the beginner series and learning a lot in the process. It's the best of all the ones I have tried so far.
That is great to hear and thanks so much
Very interesting initiative to master the world of Macro and VBA files online. I would find it even more useful if the downloadable template also included a "Word or PDF file". Learning purely from the video is too fast for me to really let it sink in. But it's just a suggestion. Thank you very much for this first lesson.
Thank you so very much, I really appreciate that Ara. I will always make the Excel file available for download and will consider a PDF as well. Thank you for your Likes, Shares & Comments. It really helps.
Can we go with click on item image to item data with use through vba code in excel.
(like amzon or flipart)
Hi and thanks very much. Yes sure this can be done. Please search my channel for 'Schedule' as I do this in many videos. I hope this helps and thanks so much.
Do you offer excel classes starting from square one all the way up to advance? Meaning if I just started using excel and I don’t know how to do anything aside from loading the sheet up and want to learn everything. Do you offer those types of classes as well?
Hi and thanks. Yes for sure. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared
Also, in my Mentorship Program, which is on sale this month, I show you how to define, design, develop and deploy your Excel-based applications for passive income while I create a comprehensive accounting application in my Mentorship Program. You can learn more about this incredible course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
I hope this helps and thanks so much.
waiting you in every Sunday 😊
Great thanks so very much. I appreciate that.
Hola Randy, emocionado de conocer vba, me sorprende lo que haces y espero que pueda lograrlo con las tutorias que impartirás, saludos y a la espera de
de los tutoriales...
Muchas gracias, realmente aprecio que Jesús
love you bro
Thank you so very much, I really appreciate that and I am happy to help and share
Perfect explanation!….but am not able to save vba project every time I reopen the code is missing and I have to rewrite it . While saving its showing “The following features cannot be saved in macro-free workbook" warning dialog” then clicked save yet it’s not working please provide me with a solution
Hi and thanks for your comment. The file must be saved as an ".xlsm" file to preserver the macros and not an xlsx file type. I hope this helps and thanks so much.
Very nice 😊
Thank you so very much, I really appreciate that
Looking forward to it😊
Great, thanks so much. I am happy to help and share
Very useful information
Great, thanks so very much
Where can I ask questions about the programs currently sold on the website? I am wondering if the excel mentorship mastermind is also for beginners who only know the most basic VBA.
Hi and thanks so much. I have a single course that is for beginners and it is from Daniel Strong, called the Ultimate VBA Course and you can find it here: bit.ly/VBACourseRandyShared
I also have this on sale for 50% off for Black Friday.
I hope this helps and thanks so much.
This is excellent Randy.
By the way, you mentioned Intermediate Training? Is that the Tuesdays training?
Hi and thanks so much Raymond. Yes, correct. Tuesday's will still be intermediate to advanced trainings were we will amazing applications in Excel. Thank you for your Likes, Shares & Comments. It really helps.
Hi, what's option explicit mean?. Thanks
Hi and thanks, it means that Variables are required to be declared. We will go over that specifically next weekend. Thank you for your Likes, Shares & Comments. It really helps.
Great for sharing
Thank you so very much, I really appreciate that
Great work and explanation...
Thank you so very much, I really appreciate that and I am excited to share this series with everyone. Make sure to share and subscribe
Hello, all your videos are excellent. May I know what screen recording software you use?
Hi and thanks so much. I am using Camtasia Studio. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Thanks
Thanks a lot sir ❤❤🇧🇩🇧🇩from Bangladesh
For sure, you are very welcome and happy to help and share
Thank you
For sure, you are very welcome and I am happy to help and share
Thanks for sharing! What is the next video from this?
Hi and thanks very much. You can follow this playlist which will always have all of the Basic VBA Training, in order:
th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
I hope this helps and thanks so much.
Great video Please make a tutorials video how to connect excel to msword, powerpoint, visio etc(define object as to open application and execute macro in orher application like ms word powerpoint visio etc
HI and thanks, Its a nice idea and I have added it to my list of videos to create in the near future. thanks again
Hi, very interesting videos indeed... I made years ago vba files with a calendar in userforms. This ocx cannot be added in new excel versions and doesn't exist anymore in new excel. I've found an userform in internet that do the same work. But is it possible to insert an userform in an userform ? Do you know other solutions ? Thanks for your videos very useful...
Hi and thanks, yes sure its certainly possible. Le'ts assume you have a userform with a date field and you want a date picker to pop up, you can have this. Just set the Show Modal to False on the first userform which will allow the 2nd to be shown. I hope this helps and thanks so much.
Hi, can I get the Variables types so I can check it out and learn
Hi and thankms, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
If i download Excel have codes how to see those codes and data i have an excel sheet with codes and i wants to develop and make new things but i I need some of those codes inside it i tried many ways to see but not succeed ?
HI and thanks very much. You can press Alt + F11 to see the codes. This is the shortcut to view the VBA Editor.
I hope this helps and thanks so much.
Kindly sir Make a Video for "Stationery Shop" like The Video Of "COFEE SHOP POS".
please sir it's a request to you that makes a video on POS with Sales report and Inventory Management system fully Automatic for A Stationery Shop please.
Hi and thanks so much. You are welcome to download and customize the Coffee Shop POS for stationary. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
How do I get the worksheets for the exercise? The link doesn't work.
HI and thanks so much. I also just realized that Bitly link shortener is having an issue.
Please feel free to download your workbook with the following link and thanks for your patience
www.dropbox.com/scl/fi/skc8b1oqa1mq6gtm51sf4/Getting_Started_With_VBA.xlsm?rlkey=8omdbocrt72e6cmis3g36iz1o&dl=1
VBA learning still important?
Can I do this by copilot 365 and ai tools?????
What should I do
Yes absolutely important. I go over the 'Why' in this video. I also have a video on how to create an application with ChatGPT here: th-cam.com/video/0hF6zR7APUs/w-d-xo.html
I hope this helps and thanks so much.
Great 🎉
Thanks so very much, Tarek. I am happy to help and share.
Sir Please Teach Ms Access 🙏
Hi and thanks for your comment. I am only focused on Excel at this time. Thank you for your Likes, Shares & Comments. It really helps.
Hello, is there a way to hide tabs when I hide a tab then I get a VBA error. for example. I have a calculations tab and when I hide it. and run my macro the error is for the calculation sheet. I want others to use on my job but don't want them to see certain tabs. Thanks
HI and thanks very much. You should be able to calculate a hidden sheet. The only thing you cannot do i select a cell in a hidden sheet. 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.
None of your links are open. I can't access the course.
Hi and thanks. I have checked all of the links and they seem to be working fine. You may have a firewall or some protection preventing you to reach the destination.
You may want to try from another location or computer
Is your lectures available in URDU LANGUAGE or URDU translation???
Hi and thanks so much. Yes I do have subtitles in URDU for every training. I hope this helps and thanks so much.
Can you help me resolve an issue? I got the free workbook in my email but Bitdefender tried to block the link because it said it was an untrusted webpage. Also, after I downloaded the workbook, Excel has a red bar at the top and says Microsoft has blocked the macros because the source of the file is untrusted. Excel won't even let me mark the file as trusted. Any ideas?
Hi and thanks very much. I can assure you it is safe as I have programmed it myself. Bitdefender get's a log of things wrong. Concerning the red bar, as an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
@ExcelForFreelancers It does help and thank you.
Mine only displays sheet 1 and this workbook.
Hi and thanks for your comment. You can press Alt + F11 to get into the Visual Basic Editor.
I hope this helps and thanks so much.
I need help in excel
Hi and thanks. I am very happy to help. I will be creating these tutorials each and every Saturday. It will be great to have you join us. Thank you for your Likes, Shares & Comments. It really helps.
Phyton was coupled with !! Beter
Thanks so much. I very likely may get into Python training in the future if enough people request it. Thanks for your support. Much appreciated
@@ExcelForFreelancers Me.. I like to learn the python automation with excel.
Just FYI - It's very difficult to be a Mac user for Office. I have to use my old Macs to create dialog boxes. Really?? Does MS not realize Mac users are customers, a.k.a. a source of money?????
Yes I agree with you. The issues between Microsoft and Apple go back many, many years. It's extremely frustrating for users.
Is Microsoft going to kill off VBA?
Absolutely Not. I address this in the video. Thanks so much for watching.
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm