How To Create And Use Worksheet Events In Excel For Beginners
HTML-код
- Опубликовано: 8 июл 2024
- 😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🔥GET 300 OF MY BEST TEMPLATES HERE► rebrand.ly/300Wkbks_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN RUclips MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I share with you everything you need to know about worksheet events, as we drill down specifically into Worksheet Change Events and Worksheet Selection Change Events. This tutorial is perfect for those just getting started with VBA.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/WorksheetEvents_WkbkDl
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
00:46 - What Is A Worksheet Event?
01:17 - Worksheet Events
03:54 - Worksheet Change
20:54 - Worksheet Selection Change
25:47 - Before Double Click
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#ExcelForFreelancers #worksheetevent #worksheetevents #sheetChangeevents #ExcelVBA #VBABasics
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom
mr.Austin you're next level good im glad i found your content!
Mr. Austin I Always wandered for your incredible explanation ! Your are an Angel Realy
thanks a lot.
Thank you so very much, I really appreciate that Simeon, Thank you for your Likes, Shares & Comments. It really helps.
OMG !!! where does your inspiration come from Randy?
Your explanation is way too clear. Anyone who understands english can understand your trainings.
And even by watching only we can understand you.
Thanks so much !!!
Great Keita, I am super glad you enjoy these basic trainings and I am really glad to help and share. Much appreciated. Thank you for your Likes, Shares & Comments. It really helps.
Super lecture by Randy as usual 👏👏
Great, thanks so much Raymond. I am so glad you enjoyed it.
Please also make a video on array.
HI and thanks. Yes for sure we will be covering arrays when we complete the foundational VBA functions.
I hope this helps and thanks so much.
Great examples! Really handy!
Thanks so much Robbie, I really appreciate that
Brilliant stuff I'm becoming addicted to ur vids and the overwhelming potential of Excel! Just out of curiosity for fun, have you ever designed a "lotto power ball template" with all the random probabilities of selecting numbers?
Hi and thanks so much for your comment. I am so glad you enjoy the training. I have not designed a lotto power ball template, however it is certainly something I would consider if i get enough requests.
Thank you for your Likes, Shares & Comments. It really helps.
Can plz explain "Dim Attrow As Long". (17:45)
Why using Dim and Long function
Also plz explain 5th line
Range("B"& attrow).value=Target.value
Hi and thanks the AttRow is the first available row in which we will place the newest Attendee. We use a long variable to hold this whole #. To learn more about these variables please check out my series here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z
I hope this helps and thanks so much.
Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed and thanks always for your continued support.
fantastic training! one questione: is possible, maybe using an event, to force excel to wait some time? i'm creating a routine to refresh a pivot then save a copy of the workbook but often the file is duplicated before the update of all the pivots!!!
Hi and thanks. Yes for sure. You can use the Application.wait command to add any length of time to pause your code.
I hope this helps and thanks so much.
Hola, es posible fijar una fila superior (títulos) y una fila inferior (resultados) al mismo tiempo? Gracias.
Hola y gracias. Estoy seguro de que es posible. ¿Tiene un ejemplo de cómo se puede utilizar esto para poder indicarle la dirección correcta?
Thank you so much Randy for your great videos. Thank you so much for giving so much values for free. You've really helped me a lot. God bless you sir.
For sure, you are very welcome and I am so happy to be able to help and share. Much appreciated.
THNX Randy nice Video
For sure, you are very welcome Henk and I am happy to help and share
Good job!!
Thank you so very much, I really appreciate that
Sir why did you use immediate window to enable the events and why it was disabled
Thank you
Hi and thanks so much for your comment. Within a macro we often disable events to make the code run faster, but we must enable it before the macro ends. If there is a bug inside the macro, and the macro ends before events can be enabled, then we still must enable events. One way to do this is through the immediate window and another way is just to write a one line macro and run it like this
Sub EnableEvents()
Application.EnableEvents = True
End Sub
I hope this helps and thanks so much.
great training - Can you only have one change event per sheet. E.g you can't have 2 Worksheet_Change Events or any of the other change events more than once
Hi Peter, within the change event you can have an unlimited number of event codes. I hope this helps and thanks so much.
Sir I have 2 questions No1.Sir can you tell what is a meaning of “Target” and which role is playing in code. No2. at 22:58 why did you (“G” & Target.Row).ValueEmpty Then I no what is it doing but I am not getting the logic behind it so please tell me Thank you..
Hi and thanks. Target is the cell you have changed and target.Row is the row of the changed cell. 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
Randy, thank you! again, I did the codes as you were playing the teaching and enjoyed, but I notices that when you click 4 to 5 times on the checked and unchecked cell for ADDED Items row (Keep in mind same cell) it jumps into the Enter Name field cell? How is that possible? can you explain? Thanks
Hi Jorge, thanks very much for your comment and glad you liked the training. When we use the selection change event, after we select a cell and excel performs whatever action we want it to perform, we may want to click the same cell again, however we can't do that because the current cell is already selected.
So we tell Excel to select another cell using the Select command such as
Range("A1").Select
This allows us to select the same cell multiple times without having to select another cell first.
I hope this helps and thanks so much.