How To Create And Use Worksheet Events In Excel For Beginners

Рет қаралды 8,533

Күн бұрын

😎 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 KZfaq 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

Пікірлер: 36

@ExcelForFreelancers Ай бұрын

🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom

@viniciussardenberg706 Ай бұрын

mr.Austin you're next level good im glad i found your content!

@Simeonzeng402 Ай бұрын

Mr. Austin I Always wandered for your incredible explanation ! Your are an Angel Realy thanks a lot.

@ExcelForFreelancers Ай бұрын

Thank you so very much, I really appreciate that Simeon, Thank you for your Likes, Shares & Comments. It really helps.

@raymondlee8951 5 ай бұрын

Super lecture by Randy as usual 👏👏

@ExcelForFreelancers 5 ай бұрын

Great, thanks so much Raymond. I am so glad you enjoyed it.

@keitamoussa2229 5 ай бұрын

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 !!!

@ExcelForFreelancers 5 ай бұрын

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.

@bittersweet340 5 ай бұрын

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?

@ExcelForFreelancers 5 ай бұрын

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.

@Robbie1987a Ай бұрын

Great examples! Really handy!

@ExcelForFreelancers Ай бұрын

Thanks so much Robbie, I really appreciate that

@hassanjaved5469 5 ай бұрын

Please also make a video on array.

@ExcelForFreelancers 5 ай бұрын

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.

@sufin957 5 ай бұрын

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

@ExcelForFreelancers 5 ай бұрын

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 kzfaq.info/sun/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.

@hallelujawefoundit 2 ай бұрын

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!!!

@ExcelForFreelancers 2 ай бұрын

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.

@SyedMuzammilMahasanShahi 5 ай бұрын

Thank you so much Randy for this amazing video.

@ExcelForFreelancers 5 ай бұрын

For sure, you are very welcome Syed and thanks always for your continued support.

@AyushmanThakur-mo3ee 4 ай бұрын

Sir why did you use immediate window to enable the events and why it was disabled Thank you

@ExcelForFreelancers 4 ай бұрын

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.

@chinedunweke6630 5 ай бұрын

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.

@ExcelForFreelancers 5 ай бұрын

For sure, you are very welcome and I am so happy to be able to help and share. Much appreciated.

@tonymoliterni 5 ай бұрын

Hola, es posible fijar una fila superior (títulos) y una fila inferior (resultados) al mismo tiempo? Gracias.

@ExcelForFreelancers 5 ай бұрын

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?

@peterjames8046 3 ай бұрын

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

@ExcelForFreelancers 3 ай бұрын

Hi Peter, within the change event you can have an unlimited number of event codes. I hope this helps and thanks so much.

@abouyoussef555 5 ай бұрын

Good job!!

@ExcelForFreelancers 5 ай бұрын

Thank you so very much, I really appreciate that

@henkvinck888 5 ай бұрын

THNX Randy nice Video

@ExcelForFreelancers 5 ай бұрын

For sure, you are very welcome Henk and I am happy to help and share

@TarunKumar-on1df 5 ай бұрын

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..

@ExcelForFreelancers 5 ай бұрын

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

@jorgepalomera6009 5 ай бұрын

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

@ExcelForFreelancers 5 ай бұрын

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.