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

[@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