How To Master Drag & Drop Shapes In Excel VBA From Scratch

preview_player
Показать описание

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:

GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
• Add Unscheduled Appointments
• Pop-Up Date Picker
• New Job Via Drag & Drop

EXCEL COURSES:

EXCEL PRODUCTS:

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

Follow me on my Social Media Accounts:

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:

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
Рекомендации по теме
Комментарии
Автор

Amazing video! Do you have another video explaining how to moving the shape basing duration of the task?

marianavital
Автор

Fantastic and easy to follow project. Thank you for another great lesson.

tjwooten
Автор

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

rnunez
Автор

Please Mr Austin can you do a tutorial on how to prevent duplicate entry when saving data from one worksheet to another

samuelturkson
Автор

hello Randy, can't wait to follow the lesson!!

hallelujawefoundit
Автор

May i ask you, what is the the shortest excel vba tutorial here that's not shorts

kiendra
Автор

Thank you so much Randy for this amazing video.

SyedMuzammilMahasanShahi
Автор

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?

muratkrasniy
Автор

This is very useful feature. Thanks for sharing.

czechyorker
Автор

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.

Mr-J...
Автор

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.

tonyhughes
Автор

Randy, do you have courses for complete newbies, please?

MrTosha
Автор

Randy, Randy, Randy I'll just say I can't wait,

sasifexcelsolutions
Автор

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

prasantameitei
Автор

I think this is more beautiful in userform.

donasolliro