How To Create Dynamic Buttons To Change Themes, Printers & Calendars In Excel

🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_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 KZbin MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to create dynamic buttons.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/DynamicButtons_Wb
🤑 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 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_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
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:39 - Overview
5:48 - Update Printer List
12:00 - Open Printer List
17:02 - Increase & Decrease Print Number
17:42 - Print Order
25:58 - Mouse Move
35:46 - Mouse Move Hover Black
36:10 - Button Color Change
42:16 - Hide Menu
46:22 - Selection Change Event
50:48 - Show Call Con
53:58 - Show Calendar
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
#exceltraining #dynamicbuttons #excelbuttons #themechange

[@ExcelForFreelancers]

🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom

[@sasavienne]

You take Excel to a fully new level. Man your efforts are highly appreciated.. What is that??? More than amazing.. Thank you so much...

[@ExcelForFreelancers]

Thank you so much K D, I am so happy you found the training helpful.

[@ltcmdc1782]

Wow, this is all really great information. Thank you. Best VBA on this subject that I have found. I combed like 4 or 5 videos and your made the most sense. Thank you again.

[@ExcelForFreelancers]

Awesome to hear that. There is so much potential. Thank you for your Likes, Shares & Comments. It really helps.

[@saidyahya7343]

Veeeeeeery powerful. Something I have never seen before. Thanks randy

[@ExcelForFreelancers]

Thank you so much Said, Really glad you liked it.

[@richardhainsworth9428]

Loving this....thanks once again Randy

[@ExcelForFreelancers]

Thank you so much Richard. I thought you would like this one.

[@rakeshbond009]

Really appreciate your efforts. You always bring something new and suitable Solutions

[@ExcelForFreelancers]

Thanks so much Rakesh, I am really glad you enjoyed the training.

[@pcsoftonline8173]

great tutorial, once again!

[@ExcelForFreelancers]

Thanks so much. I do appreciate that.

[@SyedMuzammilMahasanShahi]

This is so so so beautiful. Thanks Randy for this amazing video.

[@ExcelForFreelancers]

For sure, you are very welcome Syed, I am glad you liked it.

[@SyedMuzammilMahasanShahi]

@@ExcelForFreelancers Sure did. Your work is fab

[@samketidlamini5317]

Thanks a million Randy

[@ExcelForFreelancers]

For sure, you are very welcome Samketi

[@toyounes]

Vous etes vraiment expert bravo

[@ExcelForFreelancers]

Merci beaucoup. Je suis vraiment content que vous ayez apprécié l'entraînement

[@medkari]

Thank you very much about your efforts for us

[@ExcelForFreelancers]

For sure, you are very welcome Med

[@jasondada5705]

Excellent 👌

[@ExcelForFreelancers]

Thanks so much, I am really glad you enjoyed the training.

[@mohamedshalaby3000]

We love you Randy

[@ExcelForFreelancers]

Thank you so much Mohamed, I really appreciate that.

[@anisshah2863]

awesome idea exal legend

[@ExcelForFreelancers]

Thank you very much Anis

[@SuperKucinghitam]

Thanks

[@ExcelForFreelancers]

For sure, you are very welcome

[@mohsin00772]

Thx .your excel idea awesome Please make video for excel family hirechry ( tree) chart from community base excel database .

[@ExcelForFreelancers]

Hi thanks very much for your comment. I will do my best to add that training. Much appreciated.

[@edwinmiranda4005]

At 6:30 you can also leave it in one line instead of 2 separate lines if you put “Dim RowNum as long, PrintNum as long” Personally I prefer to write it in a single line but that’s just me, great video by the way!

[@ExcelForFreelancers]

I used to always do that but then some people got confused, I also like one line as well. I will try to do that more often since it takes up less space. Thanks so much for the feedback.

[@edwinmiranda4005]

Excel For Freelancers oh yea you’re right, you are training people so it makes sense to separate them! I didn’t think of that!

[@1shortv]

Good job

[@ExcelForFreelancers]

Thank you very much Hamza`

[@brianyeitz1380]

Another awesome video. thank you so much. QUESTION, Is there a way to create something that sends a text message from excel to maybe 100 people? I would love to notify residents when to move there car after a snow storm via the spread sheet.

[@ExcelForFreelancers]

Hi Brian, thanks for your suggestion. I have had a lot of requests for this. Excel alone, from my understanding cannot handle this, but it could with a 3rd party program such as Twilio. I am thinking to make a video on this however users would pay on a per-use base for Twilio.

[@brianyeitz1380]

@@ExcelForFreelancers That would be awsum. You take excel to a new level. Your videos are well done !

[@vinerguigreffou351]

you do an incredible job but also if you could create a button to be able to choose the language (French Spanish) all your applications are English

[@ExcelForFreelancers]

Hi and thanks so much for your suggestion. I appreciate that. Thank you for your Likes, Shares & Comments. It really helps.

[@vinerguigreffou351]

@@ExcelForFreelancers good evening ok for now this is the only suggestion that I have the possibility to change the language of an application besides English would be great

[@erikguzik8204]

I really like the Drop down menu trick with the button and the Arrow to display the drop down from the cell under it... On my computer when i do it, the NUM LOCK comes up on the screen, it doesn't change states just displays like you pressed the numlock key 2x. So the work around doesn't seem to work for me.

[@ExcelForFreelancers]

Hi Erik, thanks so much for your comment. I understand about the NUM LOCK issue which is an Excel bug, You can solve this issue by using Sendkeys to correct this issue. I hope this helps and thanks. More information on that here: stackoverflow.com/questions/25977933/sendkeys-is-messing-with-my-numlock-key-via-vba-code-in-access-form Thank you for your Likes, Shares & Comments. It really helps.

[@mky19]

Dear Randy, Please make PROJECT WISE PO/INVICE/BILLS/RECORDS/UPDATE/EDIT/PAYMENTS RECEIVED/TDS/DEDUCTION DETAILS/GST ETC

[@ExcelForFreelancers]

Hi thanks so much. I am doing all of that in the Accounting application I will be developing in our private Mentorship Program starting this month. Please make sure you are on our email list here: www.ExcelForFreelancers.com

[@charlesdjetou2906]

si tu pouvais sous-titrer en français ça sera mieux pour nous qui ne comprenons pas trop l'anglais

[@ExcelForFreelancers]

Salut je suis incapable de lire ou écrire la langue française

[@charlesdjetou2906]

@@ExcelForFreelancers franchement vos video me font du bien merci pour tout

[@ExcelForFreelancers]

@@charlesdjetou2906 Vous êtes les bienvenus

[@charlesdjetou2906]

@@ExcelForFreelancers merci