Mastering The Select Case Statement In Excel VBA | Full Tutorial
Рет қаралды 6,951
Күн бұрын😎 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 will share with you a complete masterclass on how to use the powerful Select Case Statement in Excel VBA, along with real-world samples and a complete and free workbook download
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/SelectCaseStatmnt_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
3:26 - Basic Select Case Statement
6:32 - Multiple Condition Value
8:08 - Multiple Condition String
9:22 - Select Case With A Range Of Data
10:40 - Select Case With Multiple Wildcards
17:45 - Send Email Select Case
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 #selectcasesatement #Excelvba #VBAtutorial #SelectCase #ExcelSelectCase
@ExcelForFreelancers Ай бұрын
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom
@SM-tz1hc 5 ай бұрын
I'm still speechless at what you do. you are a true master❤❤❤😮😮😮😮😮😮😮
@ExcelForFreelancers 5 ай бұрын
Great and thanks so much for your continued support
@carloscrespo-riera9815 5 ай бұрын
Randy, again, thanks so much for sharing your knowledge and taking the time to educate all of us.
@ExcelForFreelancers 5 ай бұрын
For sure, you are very welcome Carlos. I am happy to help and share
@SyedMuzammilMahasanShahi 5 ай бұрын
Thanks Randy for this amazing video.
@ExcelForFreelancers 5 ай бұрын
For sure, you are very welcome Syed. I am happy to help and share
@peterjames8046 5 ай бұрын
Excellent training Randy, looking forward to the next one
@ExcelForFreelancers 5 ай бұрын
Thank you so very much, I really appreciate that Peter
@guillermohernandez-trejo9045 5 ай бұрын
Great your videos and great your explanations, Thanks Randy from North Carolina.
@ExcelForFreelancers 5 ай бұрын
For sure, you are very welcome Guillermo, I am happy I could help
@ExcelMadeEasy444 5 ай бұрын
Nice Explained.
@ExcelForFreelancers 5 ай бұрын
Thank you so very much, I really appreciate that
@alializadeh8195 5 ай бұрын
Thanks
@ExcelForFreelancers 5 ай бұрын
For sure, you are very welcome and happy to help
@mkhanapathan 5 ай бұрын
I have been programming for a long time but learning is a never ending journey and I always enjoy watching your videos aa one can learn something new and/or ways of doing something in totally different manner - often more efficiently. Thank you p. s. in your bakery manager system, it would be good to see batch allocation for stock which can show your users how to track multiple batch stocks (stock from one batch utilised in multiple product makeup and multiple deliveries in one product i.e. limited stock available from one delivery for product makeup needing partial stock from another delivery to be allocated) and see in the BOM multiple batch numbers from which stock has been used along with the allocated stock from each.
@ExcelForFreelancers 5 ай бұрын
Hi and thanks so much. I am glad you enjoyed the training. Thanks also for the tip on the Bakery Manager. Very good point. I will try to incorporate that in a future video. Thank you for your Likes, Shares & Comments. It really helps.
@mkhanapathan 5 ай бұрын
@@ExcelForFreelancers I think my wife will be getting upset with you as I am a night owl and I am hooked on your videos 😊
@ExcelForFreelancers 5 ай бұрын
Hahah thanks so much. I hope i don't get you into too much trouble
@robertbateman3665 5 ай бұрын
Select Case is great if you have several "ELSEIFs" with multiple conditions. As always, another great tutorial. Thanks!
@ExcelForFreelancers 5 ай бұрын
Absolutely! Thanks so much for sharing Robert :)
@klebersonmoreira1821 5 ай бұрын
Sensacional, obrigado por compartilhar seus conhecimentos. Mestre, como carregar dados do Treeview no Listview?
@ExcelForFreelancers 5 ай бұрын
Olá e muito obrigado. Tenho um treinamento sobre Tree View aqui você pode gostar: kzfaq.info/get/bejne/j9Okl81oqMW3o3k.html Espero que isso ajude e muito obrigado.
@nilzomanjate321 5 ай бұрын
Amazing! Thanks very much, great video, it will save tons of working hours. ❤
@ExcelForFreelancers 5 ай бұрын
Great, thanks so much and I am happy to help and share
@williamcrockett8511 5 ай бұрын
He takes this from "Axis Of Awesome, for chords song"
@ExcelForFreelancers 5 ай бұрын
Thank you so very much, I really appreciate that William
@vinerguigreffou351 5 ай бұрын
hello sir first of all thank you for everything but I would like you to create an excel application for creating entry tickets for events and also that it is possible to scan the ticket with the software at the entrance to avoid fraud
@ExcelForFreelancers 5 ай бұрын
Hi and thanks so much. Yes i have that already here: kzfaq.info/get/bejne/qZeJmsurnZqwh30.html I hope this helps and thanks so much.
@ExcelForFreelancers 4 ай бұрын
🤖Speed Up Excel Tasks with AI-Powered Solutions ► bit.ly/AIToolpack_Com
Excel For Freelancers
Рет қаралды 15 М.
Полярная звезда - Kuzey Yıldızı
Рет қаралды 7 МЛН
Excel For Freelancers
Рет қаралды 8 М.
Excel For Freelancers
Рет қаралды 19 М.
Полярная звезда - Kuzey Yıldızı
Рет қаралды 7 МЛН