How To Master Drag & Drop Shapes In Excel VBA From Scratch
Вставка
- Опубліковано 28 лип 2024
- 🎁 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 UA-cam MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this masterclass, I take you step by step over the process flow, VBA and steps into turning any application into a powerful drag & drop app. We create a basic scheduler from scratch to teach you everything you need to know about how to use this feature in any application you develop.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/DragAndDropShapes_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 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
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
0:36 - Overview
3:20 - Designing Main Sheet
21:25 - Refresh Schedule
35:08 - Select Job Schedule Macro
39:59 - Load Job
41:42 - Next Week Schedule
42:53 - Check For Move DragDrop Macro
54:51 - Refresh Schedule
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 And Saturday!
Thank you very much for your continued support,
Randy Austin
#ExcelVBA #ExcelShapes #VBAShapes #DragDrop #ExcelDrag&Drop #DragDropShapes
🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom
Fantastic and easy to follow project. Thank you for another great lesson.
Thank you so very much, I really appreciate that
Thank you so much Randy for this amazing video.
Thanks so much Syed. I am glad I can help and share
hello Randy, can't wait to follow the lesson!!
Thank you so very much, I really appreciate that and I hope you have enjoyed the training
Amazing video! Do you have another video explaining how to moving the shape basing duration of the task?
Hi and thanks very much. I believe I have done that on one of my videos however I can't remember which one. Perhaps check out my Task Manager series. I will also create a training with this feature in the near future. I hope this helps and thanks so much.
Please Mr Austin can you do a tutorial on how to prevent duplicate entry when saving data from one worksheet to another
Yes for sure. I have done this in a few videos already. I will add it again as part of another video so please make sure to watch each training completely. Thanks so much
As Usual.Great Master Piece..Thanks
Thank you so very much, I really appreciate that
This is very useful feature. Thanks for sharing.
For sure, you are very welcome and I am happy to help and share
Drag and Drop Shapes en Excel VBA from Scrash, super. Best way to learn with Randy and Excel for freelancers . Thanks so much, I can not wait.
Tenemos cita el sábado con Randy y como Arrastras y soltar formas usando vba en excel. 🥳
Thank you so very much, I really appreciate that and I am sure you are going to love this training
Hi Randy:
Don't know if you're still looking for ideas for future videos?
An application for an artist who has 100s of pictures in a variety of mediums both framed and on canvas (plus prints, cards etc.), which are exhibited for sale in multiple galleries, to record where they are, plus easily change locations, and record sales would be great.
Tony.
Hi Tony, thanks for your comment.I am always looking for new ideas. I do have a Collectors Manager in which you may be interested to help you with that here: ua-cam.com/video/lS-1cbiNbYg/v-deo.html
I hope this helps and thanks so much.
Again perfect job thanks a lot
İf it's possible, please can you guide us how we can make stock market dashboard for excel? Trading view to excel live data and dashboard is it possible?
Hi and thanks very much for your support. I will do my best to create the stock market dashboard in the future. Thank you for your Likes, Shares & Comments. It really helps.
Randy, Randy, Randy I'll just say I can't wait,
The same thing
Great thanks so much. I know you have seen tings like this before, but in this training i break it down step by step and start from scratch
I hope this helps and thanks so much.
@@ExcelForFreelancers0⁰⁰
May i ask you, what is the the shortest excel vba tutorial here that's not shorts
Hi and thanks, probably around 30 minutes. You can find the shorter ones in my Basic VBA Series here: ua-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
I hope this helps and thanks so much.
Is there a reason you don't use structured tables?
I'm particularly thinking about when you are using offsets for Named Ranges vs. leveraging structured table references.
Hi and thanks very much. I prefer ranges more than tables as i find tables very limited and also automated. Sometimes tables automate things that I don't want to be automated. There are also limits within tables. I prefer using named ranges as they are very specific within formulas and can easily be read and taught. I hope this helps and thanks so much.
Randy, do you have courses for complete newbies, please?
Hi and thanks so much. 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
I think this is more beautiful in userform.
Thank you for your Likes, Shares & Comments. It really helps.
Hello randy please make an office item's manager. With features 1 enables whom to assign the items. 2 can update which items are working or not. 3 with unique item's code. 4 addable employee and department. It will be very helpful if you cover such a manager in your next video. 🙏
Hi and thanks very much. I have something similar with my Document Manager.
ua-cam.com/video/4gIqZvR7RJo/v-deo.html
Have you see this, or is your requirements different?
It's a document manager. What I am saying is office items (Office Equipments Manager) such as computers , printers and other devices or any other assets which we can give them a unique code and can assign who use those items also. Please help or refer me if there are videos about this before.
Ah yeah that is very different. I do like your idea. I have an Asset Manager here: ua-cam.com/video/mWdQKTmKL_M/v-deo.html
However I think your idea is different and I will write it down since its quite unique and interesting and important for any office manager.
Thanks so much for sharing
@@ExcelForFreelancers yeah I already watched this one too. But the features are quite different so need your help on this.
Yes no worries, glad to help. I should get this done within a few weeks.
What versions of Excel?
Hi and thanks so much. This will work on any desktop version of Excel.
I hope this helps and thanks so much.
@@ExcelForFreelancers Good to know. Thanks.