วีดีโอ

Link Updated

Thank you so much for your kind feedback! 😊 I’m really glad you found the tutorial helpful. If you have any questions or suggestions for future topics, feel free to share-I’d love to hear from you!

Thank you for your kind words! 😊 I’m so glad you enjoyed the tutorial. Your support keeps me motivated to create more content.

Thank you so much! 😊 I’m glad you found the introduction helpful. If there’s anything specific you’d like to see in future videos, let me know-I’m always open to suggestions! 🚀

Thank you so much! 😊 I’m thrilled you found the video so comprehensive. If there are any other functions or topics you’d like me to cover, feel free to let me know-I’m always here to help! 🚀

Thank you so much for your kind words and support! 😊 It means a lot to know the videos are making a positive impact. If there’s any topic or idea you’d like me to explore, feel free to share. Happy learning! 🚀

Thanks again! 😊 I really appreciate your support and kind words. It’s great to know you’re finding the videos helpful. Let me know if there’s a topic you’d like me to dive into next! 🚀

Thank you so much! 😊 I’m thrilled you enjoyed the video. If you have any topics or questions in mind, feel free to share-I’d love to help! 🚀

Thank you! 😊 I’m so glad the explanation was helpful. If there’s anything else you’d like me to cover, feel free to let me know. Happy learning! 🚀

@@SiddharthRout Thank you for getting back. I will be really deligted to watch a video you cover the use of objects in sub/function. Passing objects to sub/functions and returning objects from them. Off course, when you are free. Thank you and have a great day!

What error are you getting?

Thank you so much for your kind words and for sharing your experience! 😊 I’m glad you found a solution to the runtime error-using If Not was a clever approach. If you ever run into more challenges or have questions, feel free to ask. Happy learning and coding!

Thank you so much for the kind words! 😊 I'm thrilled you find the videos useful. If there’s a specific topic you’d like me to cover, let me know-I’m always open to suggestions!

For this video. there is no workbook. In fact you can work with any table in Excel. Simply use that table name in your codes :)

@@SiddharthRout 👍

Glad this video helped clarify the local window for you, Rajat! If you have any other questions or topics you'd like me to cover, feel free to share. Happy coding! 🚀

The file can be downloaded using the link mentioned in the description above.

Thank you so much for the kind words! 😊 I'm really glad you're finding the videos helpful-your support keeps me motivated to share even more quality content. Stay tuned for more tutorials and insights coming your way! 🚀

I have updated the link. Please check the desciption above and thanks for bringing it to my notice :)

@@SiddharthRout Thank you so much, It is now Working and I am Just download this sample file. and could you please let me show your other training videos?!. i will follow your updated videos. Thanks again for your help.

Thank you so much! I'm glad you found the explanation clear 🙌 Your support means a lot. Stay tuned for more content like this, and feel free to drop any questions or topics you'd like me to cover! 😊

I'm profoundly interested in the Object Oreiented Programming - OOP Series. Kindly make it happen fast. Cheers!!

Hi! I’d love to dive into OOP, but I’ve been waiting for a stronger response from viewers to make sure it’s something people want. You and just a couple others have shown interest so far. If more viewers want to see it, I’d be thrilled to create this content!

@@SiddharthRout The problem is not many VBA developers would be aware that it's possible to create VBA programs in an OO way. I bet 99% of VBA developers have never heard of design patterns or SOLID principles, so obviously they won't be requesting it. However, once you've introduced it, I'm sure you'll open up more interest.

Thanks so much for the kind words! 😊 It’s awesome to hear that this advice resonates with someone experienced in advanced VBA. Even with strong coding skills, having tools like ChatGPT can sometimes add a new perspective-or help with quick ideas in Excel VBA! Let me know if there are specific VBA techniques or Excel automation topics you’d like to see covered in future videos. Thanks again for tuning in!

Thanks for sharing your thoughts! You bring up a great point about Copilot-it's definitely a powerful tool for working with VBA, especially given its seamless integration with Microsoft products and its speed. I’m actually working on my next video, which dives into how Copilot performs with Excel VBA tasks, so stay tuned! I’ll explore some of these differences in more detail. Appreciate you engaging with the content!

Thank you so much for your kind words! 😊 I'm really glad you found the video helpful and that the concepts were clear! 🙌 Your support means a lot and motivates me to keep creating more content. Stay tuned, I've got some exciting new VBA tutorials coming soon! If there’s anything specific you’d like to learn, feel free to share your ideas-I’d love to cover them! Thanks again 👍 #VBA #LearningTogether #MoreToCome

Hey Phil, great questions! I'd love to help answer them, but it might be easier if you break them down and share them in our Facebook group. You can include screenshots, examples, and get more detailed responses there. Join us here: facebook.com/groups/msexcelvba.

Hi Sid. Thank you for the quick reply and offer. Unfortunately I do not have Facebook or any social media account for that matter, so I will be patient and try to see if I can find an answer on youtube.

@@philsmith7619 In that case, email me all the details, I will try and help you through that :)

Hi Kevin. I apologize for the inconvenience. Seems like the entire folder of files got deleted. I will try and recreate the file. Please give me 24-48 hours. Thanks for bringing it to my notice!

@@SiddharthRout . Thanks, I really appreciate your quick response and your good work on StackOverflow etc

@@kevinlorenz2810 File Link has been restored. Thanks again for the headsup. :)

@@SiddharthRout Many thanks . Very helpful

Thank you for your feedback! I'm glad you found the detailed presentation on working with tables in Microsoft Excel VBA useful. Tables are powerful tools in Excel, and using VBA can make working with them even more efficient. If you have any questions about Excel tables or VBA, feel free to ask! I’ll continue creating more in-depth Excel VBA tutorials, so stay tuned.

Thank you for your kind words! I'm thrilled you found the introduction to the Visual Basic Editor helpful. My goal is to make learning VBA easy and accessible for everyone. If you’re interested in more tutorials on Excel VBA or want to dive deeper into specific topics, just let me know! I appreciate your support, and don’t forget to share it with others who are also learning VBA.

Thank you so much! I'm glad you enjoyed the video on creating a quiz app in Excel using VBA. I believe this tutorial will be helpful for many Excel VBA users who want to build interactive applications. If you have any questions or need more tutorials like this, feel free to ask. I’ll keep creating more Excel VBA content in English for the community. Thanks again for your support, and please share it with others who might benefit from learning Excel VBA!

Can you post the question on the Facebook VBA Page. Include screenshots of how the data is and also show what you expect 🙂 Do not worry, I will definitely help you. FB Link: facebook.com/groups/msexcelvba

Oh Yes. You can create a custom calendar using date functions.

Thanks for taking the time out to appreciate the video :)

Thank you so much for your kind words! 😊 I'm glad you found the detailed explanations and examples helpful. Using wildcards to search for characters is such a powerful tool in VBA! Have you tried implementing it in any specific projects yet? I'd love to hear how you're using it.

@@SiddharthRout Not yet. I do have something in mind mainly for my wife. She has an excel sheet with products listed that she makes at home and sells online. However, this list is quite long and has expanded to become quite large over the years. It is not alphabetical and not all are in a straight format there are seperate "sections" in the sheet. I will copy all this data to a new sheet along with her codes and the prices and then refer to this sheet as I think it will be easier. My idea is to be able to search this sheet for a keyword that she types in and come up with the closest matches. For example she has many key rings and in another section she has key ring holders. So a search for the word "key" should bring up all items with that word in it. This is simplified of course as sometimes the word might not be at the beginning hence why I was mentioning the wild card search. I know that the original data should have been sorted better originally, but my wife is averse to change as the way she has it is easy for her to understand when just looking for something. After watching your video a couple of times I know that I will get to understand the principles and be able to sort it out for her. I was thinking of using a list box and then making 2 boxes to search for the 2 criterea that she would use and display the results in the list box mainly "description" and/or "code", I doubt she would need to search for anything else. Then she can pick the one she wants from the displayed results to get price, cost etc. Thank you for taking an interest in my journey.

Thank you so much for your kind feedback! 🙏 I'm really glad the explanation was clear for beginners. 😊 To answer your queries: Yes, you can definitely add to a collection using a loop-it's a great way to automate the process! As for the second question, there's no strict limit on the number of items in a collection, but memory constraints can come into play if the list gets very large.

Thank you! 😊 I’m glad you found the application useful! Just to clarify, while this particular app was created using VB.NET, you can definitely make similar applications in Excel using VBA. If you want to run a form and hide Excel in the background, that’s totally possible with a few tweaks in VBA!

Yes you can hide the worksheet and the code will still work. As I mentioned in the video those sheets are for the quiz master to see. You can hide them. And the reason for that is very simple. I am not using .Activate/.Select. I have declared the objects and I am directly working with it. In fact, I have spoken about it here. Maybe my next video can be about this? :D stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba/10718179#10718179

Yes, this could definitely be helpful for your quiz application. I’m really looking forward to seeing how it turns out. 😊 And just a reminder-I’ll be uploading a new video soon with a little surprise for you, so be sure to check it out! I think you’ll find it very useful for your project. 😉

@@SiddharthRout Thank you, what a surprise to see this pop up on your channel, most unexpected but a pleasant surprise all the same. As usual you cover everything, however I will have a little play with it just as soon as I finish your course. I do have some thoughts to make some variations to it and hopefully this will give me a great start to getting a "feel" for the code. I have to say that I was expecting the code to be much, much longer, but then with my "rookie" knowledge my attempt would have been much less efficient I'm sure. Once again I can't thank you enough for this video.

Thank you so much! I’m really glad to hear that you found the explanation clear and easy to follow. 😊 I always aim to make things as detailed and understandable as possible, so it’s great to know it’s helping!

Thank you so much for your kind words! It really means a lot to hear that you’re finding the course helpful. My goal is to make learning VBA accessible for everyone, especially beginners, so your feedback is very encouraging! 😊 If you ever have any questions or need further clarification on anything, feel free to reach out. Thanks again for your support!

Thank you so much! 🙏 I'm really glad to hear that you're learning well from the course. I also want to personally thank you for taking the time to watch and comment on my videos-it means a lot! 😊

Thank you! I'm so happy to hear that the explanation and teaching style worked well for you. 😊

Thank you so much for watching and for your kind words! 🙌 I'm glad you enjoyed it. Are there any other topics you'd like to see covered next? 😊

@@SiddharthRout As I explained already I am retired now and wanted to learn something to keep me occupied. I am going to watch your full course of videos because I have a project in mind that I would like to attempt. As a beginner it may well be beyond me but I would like to try all the same. What I want to do is to create some code to make a quiz in Excel, i'm not sure if it will be multiple choice or not? But I want to have a go. Maybe some modules that could cover parts of this project? Only if you have the time and you are not busy with other projects. Thank you.

@@philsmith7619 Thank you so much for your kind words! I’m really excited that you’re planning to take on an Excel quiz project. Whether it ends up being multiple choice or not, I’m sure you’ll do great. By the way, I’m uploading a new video in about an hour, and there’s a little surprise waiting for you in there! 😊 Can’t wait for you to check it out!

Thank you so much! 🙏 I'm thrilled to hear that the course is helping, especially for someone starting out later in their journey. It's never too late to learn, and I'm glad the content is easy to follow for beginners! Keep up the great work, and feel free to ask if you have any questions along the way. 😊

Thank you! 🙌 I'm really glad you found this topic useful-it's true, it's not often covered, and I wanted to fill that gap. 😊 If there are any other rare or tricky topics you'd like me to explore, feel free to let me know. Thanks again for your support!

Hi Faiz. Yes, this feedback was given earlier. If you see the latest videos, there is no background sound :)

@@SiddharthRout okay sir. There are 50 videos of VBA on your channel. Are there any more new videos related to VBA sir ?

@@faizshaikh164 Yes there will be new videos. I am currently recording and editing. I would recommend subscribing (if you have not done it already) so that you instantly get a new alert when I post a video. In fact there is a new video coming out next week.

Already a subscriber sir . I like how you teach excel 👍. I also learned Power-Bi from you during your tra​inity class @@SiddharthRout