How To Create Your First Excel Add-in + FREE BONUS

In this training, I will show you how you can easily create your first add-in in Excel in a step-by-step tutorial. I will also share with you an incredible bonus just for you at the end of the video.

⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:

EXCEL COURSES:

EXCEL PRODUCTS:

Timestamps:
0:00 – Introduction
0:27 – Why Would We Want To Create An Add-In?
3:33 – Calculate Age
12:58 – How Add-Ins Work?

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

#ExcelAdd-in #ExcelAddin #AddinExcel

[BobMuntis]

You have answered SO many of my questions and struggles of the past 6 months with this video. I can't thank you enough! So excited to use this long weekend to build some awesome new projects now that I can store data in my add-ins. The date picker will be really helpful too! Thank you!

[RonDavidowicz]

Hi Randy, another great video.

Q: what’s the advantage of using add-ins versus saving a macro in the Personal Workbook?

[ThomasGoeson]

Lot of really great info, Randy! Gave me a lot of ideas to play around with.

[muhammadkausar]

Great sir
I only expect that from
You are amazing
Keep uploading basic tutorials like that..

[JanBolhuis]

And another great video. Thank you very much.

[Skylineview]

I would love to have a tutorial on the date picker, so that I can be used in the worksheet and another form. I have several workbooks with forms where I’ve been trying to do just that.

[taimoorkhan]

Love you videos Randy... do you have any video where we can call a command through VBA in an add-in (VBA will execute a command in the add-in rather than manually going in to Add-in and clicking on the command)

[MikeLainhart]

Thank you Randy for these videos and workbooks. I have been downloading the videos and using them to reinforce the teaching of the video. I have not been able to find out how to download the workbook for the first part of the video, but only the BONUS workbook. Please tell me how to get that first workbook. Thank you

[hcrartgallery]

Waiting with a cup of tea, looking forward to this.

[robbe]

Hello Randy,
Very useful video and a magnificent add-in you offered

I live in Belgium (Western Europe) and our date notation is "dd/mm/yyyy".
I installed your add-in but it doesn't work for our date notation.
After looking into the code, I think the error happens in the SUB Build_Calendar in the following code :

If I < Weekday((CB_Mth.Value) & "/1/" & (CB_Yr.Value))

I think the values of CB_Mth.Value and "/1/" must be switched.
Can you tell me if I am right?
If so, I would write a supplementary function with a regional parameter to set the date in the right sequence
with the chosen region.
Thank you for your help.

[rgsentertainment]

Hi Randy, thanks for sharing all your work. You guys are the best!

I have downloaded the AddIn but it gives me an error Type Mismatch and it brings me to the Line:
“With CalendarFrm” (Object variable or With block variable not set)
Why is this error?

[malcolmsokol]

Very informative. If I use the Calendar Date Picker Add In, it looks like it is triggered by selected any cell with a date format. Is there a way to use it and only have it appear for cells that are specified to respond with the picker. Otherwise I just edit the date normally. I have another date picker add currently but it is shape based and I can select a cell as a worksheet selection event and then the shape is opened and the picker is mapped to the selected cell to deliver the picked date. Would like similar functionality?

[larryduffie]

Slick stuff Randy. If you do the datepicker deep dive can you include how you might use it in a spreadsheet that is used by multiple users in one location on a shared workbook. Or did i miss it?

[donniemcgee]

Thanks you for this amazing tutorial!-- from your new minion, Don! :)

[malcolmt]

Randy
If the sheet is set to the default zoom of 100%, the date picker pops up as you say it will, however if the zoom is set higher or lower than the 100% it move, Up >100% and down <100% my date column is on column 1 (A) any change < or > from the 100% and it is gone from the screen, since I started writing this I have changed the format of the column and got it back onto the screen but the above still applies.

[ronge]

tnx Randy, great work. Question: I have the dutch version of excel and the european date = dd/mm/jj. So this datepicker doesn't work for me. What do I have to change in VBA?

[naytun]

Hello Sir, Could you please share me the link of your VBA Tutorial for beginners in the comment? Thanks

[TinfoilHat]

I really like this calculate age function as an addin, however, it does not work on Mac. Could you advise what would be needed to be changed to allow the code to be written for an Excel Mac OS function?

[ExcelExplorers]

Your performance is genuinely outstanding! Would you be open to discussing my work?🙂🙏

[DinoDelight]

This is great, I am struggling with a getcolour function that I need in multiple WBs

Function getColour (x As Range) As Interger
get Colour = x.Interger.ColorIndex

End Function

It works if it's in a module in the individual wb but won't work as an addin? It recognises the function when typing but just get the result #NAME?

Any ideas?