How To Find & Fix Multiple VBA Bugs In Excel [Data Entry Form Update]

In this week’s training, I will show you how to fix bugs and why they appear.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

EXCEL COURSES:

EXCEL PRODUCTS:


TIMESTAMPS:
0:00 - Introduction
0:31 - Overview
10:06 - Load Content
14:36 - Conditional Formatting
16:10 - Selection Change Event
17:26 - Load Contact
19:44 - New Contact
25:15 - Change Event
28:21 - Save Contact
34:19 - Delete Contact
35:51 - Attach Thumbnail Contact
38:11 - Display Thumbnail Contact

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

#exceltraining #fixingbugs #vba #debuggingexcel

[richardhainsworth]

Must admit, this is going to be a massive help. The amount of semi-built tools I have where I know I have bugs is unbelievable. Hopefully I will be able to use the info in here to finish some of them 😁😁😁

[clintg]

Looking forward to this. I spend 12 hours a day in Excel spreadsheets and desperately need the shared workbook feature you have designed. I spent a few hours testing the workbook from part 21 today and I run into issues with synching after I deleted more than one cells data at a time which I know I'm not supposed to do. Also I have issues with login screen not allowing me to sign in. I'm not familiar with the code but plan to trouble shoot soon. If I can figure out a reliable way to implement your sharing feature this will be a huge deal for me. Thanks!

[michaelfullard]

Thanks, Randy, this should be super useful.

[Strobinski]

Thanks for the great training!
I like to define global variabeles in VBA and use the first e.g. 10 rows in the sheet to avoid "magic numbers" in the code
and for the mapping works the formula =address(row(...), column(...)) fine for me :-)

[tayzaroo]

Thank you for your training and email sending.

[mdmosamiah]

Thank you for your training and I hope that link me.

[RawaeaDesigner]

File is great but when you insert a picture the phone number is deleted. Thank You