Тёмный

Master Excel MACROS & VBA in ONLY 1 HOUR! 

Подписаться
Просмотров 739 тыс.
% 9 476

In this Microsoft Excel Tutorial you will learn Excel Macros & VBA Programming inside 1 Hour! DOWNLOAD THE PRACTICE WORKBOOKS & FREE MACROS & VBA CHEAT SHEET: www.myexcelonline.com/107-160.html
I am using Excel 2016 in this VBA Excel Programming & Macro tutorial but you can also apply what I teach in Excel 2010, Excel 2013, Excel 2019 and Excel Mac versions 2011 and 2016 (as well as the latest Office 365 version).
In this Excel Macro & VBA Programming tutorial for beginners you will learn how to:
👉 Record MACROS & Write VBA Code within 1 HOUR!
👉 AUTOMATE repetitive & boring tasks with a single press of a button that will SAVE YOU Time & Money!
👉 Save and share your Macros!
👉 Debug and step into your VBA code
DOWNLOAD THE PRACTICE WORKBOOKS & FREE MACROS & VBA CHEAT SHEET: www.myexcelonline.com/107-160.html
JUMP TO AN EXCEL FORMULA & FUNCTION TUTORIAL WITHIN THIS VIDEO:
0:00:00 - Introduction
09:00 - Record a Macro
21:40 - Modify a Macro using the VBA Editor
27:30 - Save a Macro Enabled Workbook
29:30 - Insert a Worksheet & Rename it using a Macro
43:25 - Add a Macro to the Quick Access Toolbar
45:45 - How to add a Button to run a Macro
50:03 - Step into & debug your VBA code
------------
🔥 OUR BEST EXCEL RESOURCES 🔥
👨‍🏫 Get 30+ Excel & Office Courses & support for ONLY $1💵 (all levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!
Join Now for ONLY $1 (LIMITED TIME OFFER) 👉 www.myexcelonline.com/107-186.html
📚 Download Our Free 101 Excel Tips & Tricks E-Book:
Download for FREE 👉www.myexcelonline.com/101-excel-tips-e-book-youtube-channel
💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:
Access for FREE 👉www.myexcelonline.com/107-3.html
📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:
www.myexcelonline.com/107-59.html
📚101 Most Popular Excel Formulas Paperback on Amazon:
www.amazon.com/dp/1700300911
📚101 Ready To Use Excel Macros Paperback on Amazon:
www.amazon.com/dp/1700729675
📚101 Best Excel Tips & Tricks Paperback on Amazon:
www.amazon.com/101-Best-Excel-Tips-Tricks/dp/B08Z9W125P
👷 Excel Consulting Services:
www.myexcelonline.com/microsoft-excel-consulting-services/
💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
www.youtube.com/@MyExcelOnline/playlists
------------
Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)
Cheers,
JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
www.myexcelonline.com/
❤️ Let’s connect on social ❤️
LinkedIn: linkedin.com/in/johnmichaloudis
Instagram: myexcelonline
Pinterest: www.pinterest.com/myexcelonline/pins/
Facebook: groups/myexcelonline/
Twitter: myexcelonline
#MyExcelOnline #MsExcel #Macros #VBA

Опубликовано:

 

1 мар 2018

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 318   
@amirwisal3364
@amirwisal3364 2 года назад
Been trying to learn VBA from RU-vid. Watched tons of videos but this one actually was awesome. Thank you ❤️
@MyExcelOnline
@MyExcelOnline 2 года назад
That's great! Thanks for the positive feedback!
@hewalker14
@hewalker14 5 лет назад
I found this extremely Helpful. I am going for a new job and they asked if I knew macros after this session I feel confident that I can do this job to the fullest
@MyExcelOnline
@MyExcelOnline 5 лет назад
WOW that is awesome Holley! Let us know how you get on with the job interview and I am sure that you will do well :)
@fw3901
@fw3901 5 лет назад
this is amazing thanks! I watched this video for 5min(with fast forwarding) and then went ahead to build a simple VBA macro for work! I thought it's gonna take me much longer...Awesome information, thanks!
@MyExcelOnline
@MyExcelOnline 5 лет назад
Hey FW, Glad you liked this Excel Macros & VBA tutorial!
@vinodhkumar4878
@vinodhkumar4878 2 года назад
Sir can u help me I have one file that I need different format to make macro ....plz hlp me sir
@MuhammadImran-sn9lq
@MuhammadImran-sn9lq 2 года назад
Thank you John & Kyle. It was really amazing; Mr. Kyle did an awesome introduction to Macros and VBA. God bless you both.
@MyExcelOnline
@MyExcelOnline 2 года назад
Glad you enjoyed it!
@ahmednavivwala1707
@ahmednavivwala1707 8 месяцев назад
5:37
@osham5206
@osham5206 4 года назад
Such a simple and professional way to understand Macros, you're awesome guys. BEST Luck to you :)
@MyExcelOnline
@MyExcelOnline 4 года назад
Thanks for your comment and feel free to share this with your friends and colleagues :)
@jam-hu
@jam-hu 5 лет назад
jump straight to 4:10 to skip the orga stuff at the beginning. Great Video. Thanks a mil.
@rafie004
@rafie004 5 лет назад
4:24 to be exact but thanks!
@MyExcelOnline
@MyExcelOnline 5 лет назад
Hey Jamal, Glad you liked this Excel Macros & VBA tutorial!
@soundpassion-africa2874
@soundpassion-africa2874 5 лет назад
You are a great teacher. Thanks for the training
@MyExcelOnline
@MyExcelOnline 5 лет назад
I hope you learned a lot of new Excel & VBA tips!
@davidbe21
@davidbe21 2 года назад
the way you teach makes it so easy to understand , thank you .
@MyExcelOnline
@MyExcelOnline 2 года назад
You are welcome! Thanks for the compliment!
@Johnsiri
@Johnsiri 3 года назад
I think It’s not easy to simplify this , but you did it so well. Thank you very much.
@MyExcelOnline
@MyExcelOnline 3 года назад
You are welcome
@ahmednavivwala1707
@ahmednavivwala1707 8 месяцев назад
5:46
@karenmcpoyle687
@karenmcpoyle687 4 года назад
Excellent course. Very clear and organized.
@MyExcelOnline
@MyExcelOnline 4 года назад
Thanks Karen and I hope that Macros & VBA are much easier to you now!
@Chris_D_Chun
@Chris_D_Chun 5 лет назад
This is gold. very helpful thank you
@MyExcelOnline
@MyExcelOnline 5 лет назад
You are welcome Chris and make sure to check out our other awesome Excel tutorials on our RU-vid channel and over at www.myexcelonline.com/blog/
@tapansaha6624
@tapansaha6624 2 года назад
Hi ,I went though a lot of video in you tube and found your explanation is very simplest way, Thank you Kyle.
@MyExcelOnline
@MyExcelOnline 2 года назад
Oh, thank you! We try hard to make videos easy for everyone to understand.
@mauriciomunozortiz
@mauriciomunozortiz 5 лет назад
Thank you indeed for this video, very helpful.
@MyExcelOnline
@MyExcelOnline 5 лет назад
I'm glad you enjoyed this Macros & VBA tutorial Mauricio!
@ugonnac8937
@ugonnac8937 2 года назад
Wow! one of the clearest explanations of VBA code. Thanks a lot
@MyExcelOnline
@MyExcelOnline 2 года назад
Glad it was helpful! Thanks for watching.
@sandeepkothari5000
@sandeepkothari5000 6 лет назад
A wowsome webinar!
@MyExcelOnline
@MyExcelOnline 6 лет назад
Glad you enjoyed this Excel Macros & VBA tutorial Sandeep! Feel free to share with your friends :) Cheers, John
@vc8836
@vc8836 4 года назад
Why didnt i find you guys earlier.... Blessing in disguise... I learnt so much from your channel and amazing training video... Totally nerdy ;)
@MyExcelOnline
@MyExcelOnline 4 года назад
That’s awesome to hear VC! Feel free to share our channel with your friends 👍
@RW-td2hz
@RW-td2hz 5 лет назад
Wow, I never thought I would get excited about coding but this is really cool.
@MyExcelOnline
@MyExcelOnline 5 лет назад
Welcome to the exciting world of coding Roger :)
@prernaaggarwal
@prernaaggarwal 4 года назад
Thanks for the informatory videos...well explained :)
@MyExcelOnline
@MyExcelOnline 4 года назад
You are welcome 🙏
@jsennette8039
@jsennette8039 4 года назад
Nice introduction to macros and VBA code. I understood the coding itself but I often had trouble understanding looping. Your explanation of the "do while" looping code was easy to understand and now I feel confident I could use it in a similar circumstance. Thanks !!
@MyExcelOnline
@MyExcelOnline 4 года назад
We are glad that you were able to learn the "do while" looping and become more confident in Excel VBA!
@ahmednavivwala1707
@ahmednavivwala1707 8 месяцев назад
5:25
@Seftehandle
@Seftehandle 2 года назад
I really liked this presentation easy to follow through
@MyExcelOnline
@MyExcelOnline 2 года назад
Glad you liked it.
@idowubusari4453
@idowubusari4453 4 года назад
EASY ....ITS FLOWS ... YOUB ARE INDEED AN EXCEL TEACHING ANGEL
@MyExcelOnline
@MyExcelOnline 4 года назад
Thank you for your nice comments Idowu!
@bhal756
@bhal756 2 года назад
Great Job Buddy . Extremely helpful..
@MyExcelOnline
@MyExcelOnline 2 года назад
Glad to hear it!
@enockoloo3814
@enockoloo3814 Год назад
clear so professional and awesome - great job bro.
@MyExcelOnline
@MyExcelOnline Год назад
Thank you!
@TheJoshtheboss
@TheJoshtheboss Год назад
1st time looking into Macros. Wasn't sure which video to start with. Glad I started with the right one! Excellent work! Thank you.
@MyExcelOnline
@MyExcelOnline Год назад
Glad it was helpful!
@moseshunui7767
@moseshunui7767 5 лет назад
so wonderful to follow to master VBA and Macros
@MyExcelOnline
@MyExcelOnline 4 года назад
You are welcome Moses!
@vlogbossku8470
@vlogbossku8470 4 года назад
really thanks to god..i ve seen a lot video but your video i can understand very much better..really love u a lot a lot..big thumbs up from malaysia
@MyExcelOnline
@MyExcelOnline 4 года назад
You are most welcome and glad you learned how to use Macros & VBA to automate your Excel worksheets & reports!
@DanielNelson320
@DanielNelson320 2 года назад
I used to hate coding before, Aftr watching this detailed explanation I started liking coding ,hope I can master in VBA
@MyExcelOnline
@MyExcelOnline 2 года назад
Practice makes perfect Rachel, keep on Excelling!
@baumulo
@baumulo 3 года назад
Beautiful. Thank you.
@MyExcelOnline
@MyExcelOnline 3 года назад
Our pleasure!
@thatounchained9794
@thatounchained9794 5 лет назад
Loved it!!!!!
@MyExcelOnline
@MyExcelOnline 5 лет назад
I am glad you enjoyed our Macros & VBA tutorial Thato!
@ahmedshaat9968
@ahmedshaat9968 2 года назад
Man you are the best thank you for your efforts!
@MyExcelOnline
@MyExcelOnline 2 года назад
My pleasure! So glad you found this helpful!
@BenDieselBasicAutomotive
@BenDieselBasicAutomotive Год назад
Thanks for the knowledge shared....
@MyExcelOnline
@MyExcelOnline Год назад
Our pleasure! Glad you liked it!
@massefromla2554
@massefromla2554 2 года назад
Nice personality , clear and professional.
@MyExcelOnline
@MyExcelOnline 2 года назад
So nice of you. Thanks!
@narendrababumc6629
@narendrababumc6629 Год назад
very nice and much helpful in learning VB macros. Thank you so much..
@MyExcelOnline
@MyExcelOnline Год назад
Most welcome! Thanks for watching!
@lookingforwardto
@lookingforwardto 2 года назад
Nice content . Nice presentation with clear workable english. Excellent trainer & his knowledge..
@MyExcelOnline
@MyExcelOnline 2 года назад
Glad you liked it
@brendachokera8307
@brendachokera8307 6 лет назад
Well done Kyle, thanks!
@MyExcelOnline
@MyExcelOnline 6 лет назад
Glad you enjoyed this Brenda! Cheers, John
@TheBadrinath
@TheBadrinath 4 года назад
Hi
@siafawejumomo1724
@siafawejumomo1724 5 лет назад
Thanks , Love this video
@MyExcelOnline
@MyExcelOnline 5 лет назад
Im glad you enjoyed this Macros & VBA tutorial Siafa :)
@laoer_9949
@laoer_9949 6 лет назад
This is awesome!
@MyExcelOnline
@MyExcelOnline 6 лет назад
Glad you enjoyed this Excel Macros & VBA tutorial for beginners! Cheers, John
@natepfunk
@natepfunk Год назад
This is really good info. Thanks!
@MyExcelOnline
@MyExcelOnline Год назад
Thank YOU for letting us know!
@anastasiiachabanenko576
@anastasiiachabanenko576 4 года назад
thank you for this!!
@MyExcelOnline
@MyExcelOnline 4 года назад
You are most welcome Nasta!
@diachpriscilla6154
@diachpriscilla6154 2 года назад
I like this so much and it's one of my best videos on youtube
@MyExcelOnline
@MyExcelOnline 2 года назад
That's great! Thanks so much!
@tonyperkins5163
@tonyperkins5163 8 месяцев назад
This guy is an AWESOME TEACHER!
@MyExcelOnline
@MyExcelOnline 7 месяцев назад
Thank you!
@nicolewagner3267
@nicolewagner3267 6 лет назад
kyle you ROCK!
@MyExcelOnline
@MyExcelOnline 6 лет назад
Glad you enjoyed this Excel Macros & VBA tutorial for beginners! Cheers, John
@sainidhi009
@sainidhi009 4 года назад
This is excellent material! Do you have the part 2 of this course on youtube please??
@MyExcelOnline
@MyExcelOnline 4 года назад
Hey Sitara, we have more VBA tutorials over at our Academy online course here: www.myexcelonline.com/academy/enroll-eg/
@mr.a_a9407
@mr.a_a9407 3 года назад
Thank you so much.
@MyExcelOnline
@MyExcelOnline 3 года назад
You are welcome
@abdaahads
@abdaahads 2 года назад
Thank you so much!!
@MyExcelOnline
@MyExcelOnline 2 года назад
You're welcome!
@godrichotchey7648
@godrichotchey7648 Год назад
Wow! that's great
@MyExcelOnline
@MyExcelOnline Год назад
Thank you! Cheers!
@143ranagu
@143ranagu 3 года назад
Hi John, I would like to learn VBA macros more. Could you please share us more videos which is help us to learn VBA in depth.
@MyExcelOnline
@MyExcelOnline 3 года назад
Here we have 101 Macros for you: www.myexcelonline.com/blog/101-excel-macros-examples/
@reyo9377
@reyo9377 2 года назад
Thanks you are good at it
@MyExcelOnline
@MyExcelOnline 2 года назад
Thanks! Glad you liked it!
@georgeneamodia7240
@georgeneamodia7240 2 года назад
Thank you do much!
@MyExcelOnline
@MyExcelOnline 2 года назад
You're welcome!
@walekalejaiye5488
@walekalejaiye5488 3 года назад
This is very useful, clear and very precise. Do you have other tutorials like this either in Python, R, Data Science, Data Analytics, ML, or SQL
@MyExcelOnline
@MyExcelOnline 3 года назад
Unfortunately we don’t have those specific courses at the moment
@sushmithan1795
@sushmithan1795 3 года назад
Amazing teaching
@MyExcelOnline
@MyExcelOnline 3 года назад
Thank you!
@stardust7183
@stardust7183 3 года назад
You guys are GREAAAAAAAAAAAAAT
@MyExcelOnline
@MyExcelOnline 3 года назад
Thanks!
@mmmandyzhu9092
@mmmandyzhu9092 5 лет назад
Good video, and I recommend watching at 1.25x speed.
@MyExcelOnline
@MyExcelOnline 5 лет назад
Thanks for your feedback and that is a great tip!
@Youssiflagrosse
@Youssiflagrosse 5 лет назад
1.5 is fine too. I was dying... Thanks for the tip.
@ziadabdat6232
@ziadabdat6232 5 лет назад
Thank you for the tips,
@naomilago
@naomilago 9 месяцев назад
I'm watching at 2x and it's fine now
@shivanica
@shivanica 2 года назад
Thank you so much for the video. It was really helpful. I have a question, to ask you. If I have to copy a set of cells every day from a set of worksheets into a notepad and save that notepad datewise, is it possible to use macros or VBA? Please help.
@MyExcelOnline
@MyExcelOnline 2 года назад
You can create a filesystemobject and use the CreateTextFile method. Also, visit our blog for lots of tips: www.myexcelonline.com/blog/
@bigbrother_M.N.A
@bigbrother_M.N.A 2 года назад
thanks dude, now monthly work, will finish in 1 day
@MyExcelOnline
@MyExcelOnline 2 года назад
It’s possible with Macros & VBA!!!
@SomnoNaut
@SomnoNaut 4 года назад
I find it best to try and write the logic longhand in comments within cells that I would like to see in my workbook. How do others visualize the processes that they envision for their workbooks?
@MyExcelOnline
@MyExcelOnline 4 года назад
Thats a great way of doing things Claude! Each person has their own unique way of doing things inside Excel so they can easily remember how to get to a result :)
@gandharsakpal9527
@gandharsakpal9527 Год назад
Hi the Video was too informative all i wanna ask is that if i want to for eg add a month July to my worksheet and then copy the july and paste till the end of the range and then i use the same macro in the other excel sheet where the is longer than this worksheet what can i do in order to get the data till the end of the range of the new excel worksheet
@MyExcelOnline
@MyExcelOnline Год назад
Hi. Thanks for the question. Can you see the original range? If it ends in say Cell D50, just edit the D50 to the end of your new range (the cell with the end of where the July that you added is). If that doesn't answer your question, please respond in more detail.
@sml4126
@sml4126 Год назад
I have just found your site and this is exactly what I was looking for for sometime now. I consider myself an intermediate user of Excel but I want to improve my knowledge from a certified organisation such as yours. Please let me know if this online training offer is still in effect today. Thank you.
@MyExcelOnline
@MyExcelOnline Год назад
Sure! Check out our website at myexcelonline.com as we have many different options under the Courses menu. Hope you find one helpful to you!
@mariannruiz7846
@mariannruiz7846 2 года назад
Useful
@MyExcelOnline
@MyExcelOnline 2 года назад
Glad to hear that Mariann!
@murthalashafiul3648
@murthalashafiul3648 5 лет назад
so nice
@MyExcelOnline
@MyExcelOnline 5 лет назад
Glad you liked this Excel Macros & VBA tutorial!
@bankinterbankinter
@bankinterbankinter 2 года назад
Hi, this is a good vba Page. I suggest these useful macros: Workbook route in title bar Workbook name in title bar Highlight active cell Highlight active row & column Color tabs - worksheets Uncolor tabs - worksheets Number to letters
@MyExcelOnline
@MyExcelOnline 2 года назад
Thanks for the tips! Those ARE good macros.
@MyExcelOnline
@MyExcelOnline 2 года назад
And check out our site for more macros: www.myexcelonline.com/137-42.html
@logicalighting6491
@logicalighting6491 3 года назад
Hello, I want to watch this video once more before I sign up for the course. Please send me a link so I can download it and watch it. I'm 79 and it takes me longer to catch on to this stuff. Thank you for the great session. thanks, Jim
@MyExcelOnline
@MyExcelOnline 3 года назад
Hey Jim, unfortunate the video is not downloadable but you can watch it as many times as you like here 😀
@sajedezare5219
@sajedezare5219 2 года назад
Hi, I have a question: How can I create a dynamic pyramid chart that is horizontally and vertically segmented? In excel or power BI. Thanks a million.
@MyExcelOnline
@MyExcelOnline 2 года назад
Please check our blog and if you don't find the answer, feel free to contact us there. www.myexcelonline.com/blog/
@MyExcelOnline
@MyExcelOnline 4 года назад
💻Access 1,000+ Microsoft Excel video training tutorials covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE! JOIN TODAY TO ADVANCE YOUR EXCEL SKILLS 👉 www.myexcelonline.com/107-42.html
@terenceulani668
@terenceulani668 3 года назад
don't really know the magic was there in the excel .Thanks a lot to let me know..really appreciate the video
@MyExcelOnline
@MyExcelOnline 3 года назад
You are very welcome. Excel IS magical! And really fun to use!
@mojahids.hadjisiddique8747
@mojahids.hadjisiddique8747 3 года назад
thanks! Loud and clear
@MyExcelOnline
@MyExcelOnline 3 года назад
You're welcome!
@wasaytauqir213
@wasaytauqir213 2 года назад
Thanks for the video Can YOU please explain how to remain sheets using the VBA code when we want to rename each sheet a different name? I tried Activesheet.Name code after 1st sheet name but it gives error Do YOU guys have any video on that or anyone else can help?
@MyExcelOnline
@MyExcelOnline 2 года назад
Hi Wasay. Do you have a copy of the code you are trying? Sometimes it is found in Worksheets("name of sheet") . You can try that.
@musacwengasotashe6766
@musacwengasotashe6766 2 года назад
This ìs really greàt
@MyExcelOnline
@MyExcelOnline 2 года назад
Thank you!
@zeerakkhan6980
@zeerakkhan6980 4 года назад
Sir need your help about conditional formatting! I want to highlight the row whenever I type "QC" in that row, and not all the cells in that row, want to highlight only those cells in that row which are filled (not empty). please guide!
@MyExcelOnline
@MyExcelOnline 4 года назад
Please look at this tutorial which will help you out: www.myexcelonline.com/blog/conditional-format-a-cells-value/
@deepasawlani9867
@deepasawlani9867 2 года назад
The concepts are shown so very clearly. I would lie to learn about VBA coding and macros to develop automated dashboards. Could you please guide me. Thank you !
@MyExcelOnline
@MyExcelOnline 2 года назад
We have a dashboard series AND a VBA series if you'd like to check them out.
@MyExcelOnline
@MyExcelOnline 2 года назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-V6bLATFw4Vw.html
@MyExcelOnline
@MyExcelOnline 2 года назад
Also, there's an intro to dashboards in this playlist, towards the bottom: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vA2NiYiGkgs.html
@MyExcelOnline
@MyExcelOnline 2 года назад
And if you don't find what you need there, please check out our blog: www.myexcelonline.com/blog/
@Soham650
@Soham650 3 года назад
It's extremely helpfull. If you show me how we can assign any job into among some employees by using vba. It will be more helpful for me
@MyExcelOnline
@MyExcelOnline 2 года назад
Hi! Thanks for the feedback. Check our blog at www.myexcelonline.com/blog
@sday2551
@sday2551 Год назад
New to macros and looking to export data from sheet 1 to sheet 2, but only pulling through certain columns, and changing the data in those columns when it lands in sheet 2. Any ideas?
@MyExcelOnline
@MyExcelOnline Год назад
It might be better for you to use Power Query, as PQ is perfect for data transformations.
@yuval_kahan
@yuval_kahan 2 года назад
Thanks you very much blue men! 🎶im blue if i was green i was die🎶
@MyExcelOnline
@MyExcelOnline 2 года назад
HAHA! Thanks for watching.
@explorerstudio305
@explorerstudio305 3 года назад
This was a great webinar for introduction on Macros and VBA. Obviously no one can master it in 1hour, if that was the case everyone would 😂
@MyExcelOnline
@MyExcelOnline 3 года назад
You are correct! Hopefully it was enough to get you interested in VBA.
@healthvidspnoy1599
@healthvidspnoy1599 2 года назад
Nice video, I have learned new knowledge from the webinar. But the thing, this is only an introduction. lol
@MyExcelOnline
@MyExcelOnline 2 года назад
Great! Glad you now want to learn more. Check out our website and blog at www.myexcelonline.com/blog/ to learn even more!
@sk_abdul
@sk_abdul Год назад
Hey, please help in VBA Codes for the work, i have workbook with 2 sheet, data available in sheet1 and same header available in sheet2, and the code should work for it will match the header and pull the data from sheet 1and paste it in sheet2 as per the header matched. if you share the code it will help me more. thanks
@MyExcelOnline
@MyExcelOnline Год назад
Hi. Thanks for the question. That's a little more complicated that we could help with in a comment, but we have a consulting service that could help you. Please check out www.myexcelonline.com/microsoft-excel-consulting-services/
@andrewle9313
@andrewle9313 2 года назад
nice
@MyExcelOnline
@MyExcelOnline 2 года назад
Thanks
@vikaasb2016
@vikaasb2016 2 года назад
Awesome ! Your former student Kyle !!
@MyExcelOnline
@MyExcelOnline 2 года назад
Hi Kyle! Glad to see you are still using Excel! Thanks for responding!
@ismailrubel3163
@ismailrubel3163 3 года назад
Nice video & really help full .I have one question .Is it possible to build a code which already build in MATHLAB and now covert those build up code in MS Excel ? Thanks in advanced
@MyExcelOnline
@MyExcelOnline 3 года назад
Unfortunately there is no conversion tool but you can apply the same principles in VBA
@user-ov6ho1tr7i
@user-ov6ho1tr7i 7 месяцев назад
Hi, what is the technic! when sheet 1 entry sheet was complete and recorded, applying to database worksheet sheet 2 to record all rows isn't work please assist.
@MyExcelOnline
@MyExcelOnline 7 месяцев назад
Hi. Thanks for the question. Could you please let us know the timestamp in the video where you are having issues? Thank you.
@angiemowat5077
@angiemowat5077 3 года назад
when you are creating a macro to copy and paste value into another sheet, can you copy down or do you have to only go right to left?
@MyExcelOnline
@MyExcelOnline 3 года назад
You can copy whichever direction you like
@janetcheong2121
@janetcheong2121 Год назад
Hello, is this course still offer those bonuses mentioned? I'm interested, but I don't know if I will still get the same value for the course. Please let me know. Thanks!
@MyExcelOnline
@MyExcelOnline Год назад
Hey Janet yes it does! Just go to our website myexcelonline.com and drop us an email there. We will get you setup asap! 💚
@Mayur20408
@Mayur20408 2 года назад
I want to create new macro to replace given path to other tab as input given through macro
@MyExcelOnline
@MyExcelOnline 2 года назад
Please check out our blog for more info: www.myexcelonline.com/blog/
@moesadr3342
@moesadr3342 Год назад
What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?
@MyExcelOnline
@MyExcelOnline Год назад
Thanks for the question. Are you asking how you know a workbook has VBA? It should have a .xlsm extension with the m being for macro. You can upload it and share it in OneDrive or SharePoint. If Sharing, SharePoint may be better. Hope that helps!
@i.am.gamerzchoice
@i.am.gamerzchoice 5 лет назад
hi there, is it possible to download data from SAP into Excel using Excel VBA?
@MyExcelOnline
@MyExcelOnline 5 лет назад
It is best to do this using Power BI Desktop to do that. Go to: Get Data > More > In the search box type in SAP.
@fengfuxu4822
@fengfuxu4822 6 месяцев назад
thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers". Sub ListPrinters() Dim prt As Printer For Each prt In Printers Debug.Print Printer.deviceName Next prt End Sub
@MyExcelOnline
@MyExcelOnline 6 месяцев назад
Go to Tools -> References and make sure that Microsoft Access Object Library is checked.
@dannyg8307
@dannyg8307 4 года назад
Can i send Excel file through the outlook after my work completed with the help of macro
@MyExcelOnline
@MyExcelOnline 4 года назад
Here is the code to "Attach your current workbook into an Outlook email message": Sub AttachWorkbookIntoEmailMessage() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0) 'Let us create the email message and display it 'Make sure to change the parameters below With OutlookMail .To = "support@myexcelonline.com" .Subject = "Have a look at this workbook" .Body = "Hey John, Could you help out on this?" .Attachments.Add ActiveWorkbook.FullName .Display End With Set OutlookMail = Nothing Set OutlookApp = Nothing End Sub
@marko77188
@marko77188 5 месяцев назад
If anyone know other Kyle's tutorials pls make a list
@MyExcelOnline
@MyExcelOnline 5 месяцев назад
Hi. Yes, we have a complete set of Kyle's tutorials here: join.myexcelonline.com/
@paranthamanadthiya2710
@paranthamanadthiya2710 Год назад
Hi how wpuld you find the percentage of two sheets in macro
@MyExcelOnline
@MyExcelOnline Год назад
Hi. Thanks for writing! Could you please clarify what percentage you would like?
@kristiepayne9801
@kristiepayne9801 3 года назад
How do I assign a button to Clear the contents of specific cells on an excel template?
@MyExcelOnline
@MyExcelOnline 3 года назад
On the File tab, go to Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box. A new Ribbon will appear and from here you can create a button and assign a macro to that button.
@Slida79
@Slida79 5 лет назад
how to change sheet name in VBA marco in stead of week 1 etc.... ,but give diffierent name ?
@MyExcelOnline
@MyExcelOnline 5 лет назад
You can modify the code to include a list of your departments and then have the loop go through the list. You could create an ARRAY variable that holds all the department names and then loop through that. Something like this… Sub DeptWS() Dim depts(1 To 4) As String Dim i As Integer i = 1 depts(1) = "HR" depts(2) = "IT" depts(3) = "Sales" depts(4) = "Training" Do While i
@SL-uq1sx
@SL-uq1sx 4 года назад
@@MyExcelOnline you are awesome! Wonder what that example ⬆️ looks like after running macro?
@TorqueDemo
@TorqueDemo 2 года назад
Good Day sir, Hope you can help. We had an employee leave the company and he changed the passwords fo rthe VBA editor on all of our templates. He had taken most of our templates and removed the menu bars and ribbons. We cant even use the undo feature. is there a way to find the password or remove it at least?
@MyExcelOnline
@MyExcelOnline 2 года назад
Hi Colin. Yes there is a way. This video is actually on our list of one to make soon. It's a little involved, but you can do it. First, make a backup of your Excel workbook and save it to another folder just in case you make a mistake. Then work with either the iriginal file or the back up and do the following: 1. Change the extension of the protected worksheet: rename it from *.xlsx to *.zip. 2. Open the ZIP File, double-click the "xl" folder, and then open the "worksheets" folder. 3. In there, you can find the spreadsheets (in .xml format). 4. Open a sheet file in Notepad. Now search for the content:
@NakedBandito247
@NakedBandito247 4 года назад
Very helpful, but definitely watch at 1.25x speed, otherwise it's gonna be a long watch
@MyExcelOnline
@MyExcelOnline 4 года назад
Good tip!
@user-yn8oj9kr7c
@user-yn8oj9kr7c 10 месяцев назад
Can I record a ctrl+replace. I want to be able to hit a button and it replaces all of this year (year inputed in a certain cell) with next year (year put in another cell) but ctrl replace doesn't seem to be able to take info from a certain cell
@MyExcelOnline
@MyExcelOnline 10 месяцев назад
Thanks for the question. CTRL+F will help you to get to replace dialog box.
@user-yn8oj9kr7c
@user-yn8oj9kr7c 10 месяцев назад
Yes, but I want to add it to a macro, if possible@@MyExcelOnline
@MyExcelOnline
@MyExcelOnline 6 месяцев назад
Are you asking if CTRL+F can be used to run a macro? No because it is already reserved. You may be able to use CTRL+SHIFT+F.
@spyxxx566
@spyxxx566 5 лет назад
That Delete Confirmation Popup can get annoying after a while. Is there a macro to disable that?
@MyExcelOnline
@MyExcelOnline 5 лет назад
Hey Nam, can you please explain when this is happening to you?
@spyxxx566
@spyxxx566 5 лет назад
@@MyExcelOnline when. The macro delete the worksheet
@MyExcelOnline
@MyExcelOnline 5 лет назад
@@spyxxx566 Application.DisplayAlerts = False
@dainguyen-vm8ys
@dainguyen-vm8ys Год назад
Hello, when I uploaded the excel file to OneDrive, the developer tab disappeared, and I could not enable developer tab for the excel file stored in OneDrive. Please help!
@MyExcelOnline
@MyExcelOnline Год назад
Hi. I would suggest opening Excel and right clicking on the ribbon and choosing Customize the Ribbon.... On the right side of the screen you should be able to check the Developer ribbon again. Please let us know if you have anymore questions!
@healthvidspnoy1599
@healthvidspnoy1599 2 года назад
how and where to know that code like dim "i" adding of a worksheet?
@MyExcelOnline
@MyExcelOnline 2 года назад
Are you wanting to use code to add a worksheet? Dim i as Worksheet and then the next line would be Set i = ActiveWorkbook.Sheets.Add
@gollaswapna5311
@gollaswapna5311 2 года назад
how to apply macro recorded to another excel which have more rows compared to the recorded macro?
@MyExcelOnline
@MyExcelOnline 2 года назад
You'd have to adjust the row count in the VBA code. Can you provide some code here? Or visit our blog at www.myexcelonline.com/blog/
@osvaldocarmona1747
@osvaldocarmona1747 3 года назад
Hello everyone! New to VBA and was hoping you could help me put. I am trying to hide rows (all the sam rows) in multiple sheets. Is there a quick vba that you can think off? Current I have DIM R1 as string, R2 as string..R1 = range("AC2"), R2 = range ("AD2")...rows(R1 & ":" &R2) .entirerow.hidden = true...there are about 30 rows i need to hide and about 11 sheets, so you can imagine with the script I currently have, how long it is...im sure there is a more advanced and shorter way to write this..please help!
@MyExcelOnline
@MyExcelOnline 3 года назад
Hi. I am thinking this may work (the code hides Row 2, but you can put in the correct row that you would like to hide): Dim wsh As Worksheet For Each wsh In Worksheets wsh.Select Rows("2:2").Select Selection.EntireRow.Hidden = True Next wsh
@SomnoNaut
@SomnoNaut 4 года назад
How can "i" stand for two things at once? i=1 and i=i+1. Is the first i a variable and the second a loop variable or something specific to the loop? I don't get it.
@prashantsharma859
@prashantsharma859 4 года назад
i=1 (First Instance) declares the value of i as 1. Then conditions are checked ie, 1
@MyExcelOnline
@MyExcelOnline 4 года назад
They’re the same variable. One of the benefits of working with variables is they can change their value as the procedure runs. In this case we initialize “i” to be equal to 1. But each time it loops we increase the current value of “i” by 1. You do have the option to create static variables that can’t change their value. But in this case we want the variable to be able to change.