Program VBA Like A Pro And In Half The Time With AutoHotkey & Automate Excel [With Free Download]

[@ExcelForFreelancers]

⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack

[@papnyanamah2748]

You’re a VBA library. Thanks for always sharing your knowledge with us. I was getting confused and frustrated with VBA and then you appeared. Your coming has reinvigorated me to continue learning VBA. 🙏

[@ExcelForFreelancers]

Hi thanks so much. I really appreciate that. I do have a free VBA course on my site, taught by MVP Sumit Bansal here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

[@bicavalgyalvesdesousa2526]

Oh my God, I running out of word to thank you for your motivation on sharing your knowledge without any strings attached

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. Make sure you check out tomorrows video where i will teach you how to sync Excel and Google sheets (both ways) in real time!. Thank you for your Likes, Shares & Comments. It really helps.

[@chiranjeevigaddam6213]

Sir , You are awesome . Your classes are great to learn vba

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@vnunoribeiro]

My name is Vitor Ribeiro and I’m from Portugal, I work in a very small and recent company that essentially dedicates to the production of kitchen furniture and wardrobes. My job is to design in Alphacam the components of each cabinet for the machining in the CNC drilling machine. Furthermore, I also make the cutting plan of the components for each piece of furniture, in an Excel sheet made by me. I manually insert the measurements for the side panels, back panels, shelves, bottoms and tops of the cabinets. What I could use is an Excel sheet that would automatically insert the components and its measurements when I enter the name of the cabinet and its dimensions. I am aware that there is specific software for this purpose, however, our company cannot currently afford it. This would be of major utility and value for me, in the sense that I could not only avoid errors in the measurements, but it would also save me the work of inserting them all every time for each piece of furniture. I realise that this kind of sheet is complex and has many variables, but with your help maybe I could start to create a useful tool for the calculation of the components for each piece of furniture in a single list. Thank you very much.

[@ExcelForFreelancers]

Hi and thanks for your information. While I am unable to take on any projects we have 35,000 Excel Freelancers in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Just create a post with all of the details and mark it as a PAID JOB. Thanks so much.

[@vnunoribeiro]

@@ExcelForFreelancers Thank you.

[@chiwilanjabulosikwila3487]

Hey Randy, did you share the VBA Accelerator script? I could not see it in the list of links.

[@ExcelForFreelancers]

Hi and thanks yes it should be included, just look for an ahk file, if not you can download it from here: www.dropbox.com/scl/fi/0y2tc218duft53td8mrn4/VBA_Accelerator.ahk?rlkey=xvsax7nth3i95rbhapy7h0mha&dl=1 I hope this helps and thanks so much.

[@gorflunk]

Randy, you commented that for the training videos you don't use AutoMacro. How about doing a training video where you DO use the Add-In. That would show the real power behind these types of "helpers". Also, you need to know what type of MSOffice version is on your machine if you decide to download this Add-In. How to determine this? Open a blank Excel worksheet then click in this order: File->Account->About Excel and at the top of the page you will see a long MSO number followed by either 32-bit or 64-bit. Download accordingly following the instructions on the website for AutoMacro. Before you ask, yes I do use this and other code generators. The ability to store and recall favorite code snippets (Code Libraries) is one of the best features of these apps IMHO. As always, thanks for your tutorials and the guidance you share with us every week.

[@ExcelForFreelancers]

Hi and thanks so much. I opted for 32 bit since it works on both types of machines for the AutoHotkey and if i created a video using AutoMacro that might frustrate some people who do not have the application and would be unwilling or unable to pay for it. I try to always create videos that anyone can learn, regardless of the version of Excel and without Addins whenever possible. I hope this helps and thanks.

[@litdv2603]

can you please provide the AHK script again. It is not in the download file? TIA. Best Regards Lars

[@ExcelForFreelancers]

Hi and thanks, yes sure, you can download it from the following link: www.dropbox.com/scl/fi/0y2tc218duft53td8mrn4/VBA_Accelerator.ahk?rlkey=xvsax7nth3i95rbhapy7h0mha&dl=1 I hope this helps and thanks so much.

[@akulanarayana5284]

Sure we support your free service on YT education.

[@ExcelForFreelancers]

Thanks so much for your support Akula. I appreciate it.

[@edravtv4367]

Thanks for sharing! I appreciate it.

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@nadirb229]

Waiting as always to learn from the best excel teacher

[@ExcelForFreelancers]

Glad to hear that. thank you Nadir.

[@DVSgolddust]

Wow, this is going to make life (work) so much easier and faster. Thank you for spending time and share knowledge to help others.

[@ExcelForFreelancers]

For sure, you are very welcome I am really happy to help.

[@saddamskst2]

I have learn lots of things in vba from you thanks sir

[@ExcelForFreelancers]

So nice of you, glad to hear that.

[@Mmaheeshttoorggal]

Thank you sir for your great learning videos, I have learned lot from your videos... really appreciated

[@ExcelForFreelancers]

For sure, you are very welcome Mahesh

[@saidyahya7343]

Hi Randy. I hope you doing well. Thanks a lot for your videos. This is something I was waiting for a looooooong time. Thank you Randy.

[@ExcelForFreelancers]

That is great Said, I am so happy to bring this to you. This one is quick, about 30 minutes. I hope you enjoy it.

[@michaeloloishuro6915]

Thanks, Randy. I had received the AHK in your Amazing Dashboards but did not make a step to review or use it. I am surely going to put it into use. I can see myself becoming a VBA Guru. All the best.

[@ExcelForFreelancers]

Hi Michael thanks so much. I am glad you got it and I am sure its going to help you code a lot quicker and more accurately. Thanks again.

[@Fath0m73]

Thanks for this! Quick question. When I open the functions menu, I do not see automation > create word doc, etc., which motivated the purchase. How do I get the function > automate feature?

[@ExcelForFreelancers]

Hi Derek, thanks so much and glad you enjoyed and purchased. You want to make sure you activate the add-on via the addons in Excel. There is more documentation directly on the main Automate VBA site, since that is not my product. I hope this helps and thanks so much.

[@mdsoibe6282]

Wow beautiful video ❣️

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Soibe

[@SyedMuzammilMahasanShahi]

Awesome as always. Thanks for the share Randy.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Syed

[@akulanarayana5284]

Randy Austin sir, This video is very unique on KZbin about this specific topic and thank you so much. A few doubts clarified one of that is how much useful autohotkey is....👍👌

[@ExcelForFreelancers]

HI thanks i was not even sure i was going to do this video, since i really enjoy creating applications, but since i had so many questions on automating code I wanted to make this special video this time to help and share.

[@crimsonk91]

Thanks for the great video training Randy, also Happy Birthday.

[@ExcelForFreelancers]

Thanks so much for the birthday wishes and I am really glad you enjoyed the training.

[@wildbillpalmer]

What a great video for VBA programmers! Thank you so much, Randy!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Bill, I am so glad you liked it.

[@basharalzubady3290]

thank you , you been so helpful

[@ExcelForFreelancers]

For sure, you are very welcome Bashar

[@jaimeteixeira2232]

Randy please add the scrip for autoHotKey for conditional formatting please?

[@ExcelForFreelancers]

HI Jaime, thanks so much for your comment and suggestion. There are hundreds of formulas that I use in Conditional Formatting, however you are welcome to download it, and add any formulas you like in AutoHotkey. I hope this helps and thanks so much.

[@jaimeteixeira2232]

@@ExcelForFreelancers thanks Mr. Randy soon I will enroll in your program. Can send the link in order for me to download please and thank you in advance.

[@openingjoke]

Hi Randy, thanks for your videos. I'm relatively new to all of these things, but purchased auto macro on your recommendation :) under the Fxs tab, I don't have the automation, cells - identify and highlight by type or column and rows options. Is that a way that you've arranged the software? I can't find how to get the other office product code!

[@ExcelForFreelancers]

Hi and thanks for your comment. Auto-macro is a great software. For support for that addin, you can email Steven directly here: [e-mail] I hope this helps and thanks so much.

[@philip6661]

hi randy i do not seem to get the zip file only the xlsm part am i doing somthing wrong any help would be great keep up the great work paul

[@ExcelForFreelancers]

Hi Philip, thanks for your comment. I will check with my manager [e-mail] on this one as it should be a zip file. You can also email her to ensure you get the zip. I hope this helps and thanks so much. I also just released kind of an update to this I think you will like here: kzbin.info/www/bejne/b4XOfalnq7Oma9E

[@ExcelForFreelancers]

Hi Philip, please download the zip file from this link here freeworkbookdownloads.s3.us-east-2.amazonaws.com/ProgramVBALikeAPro.zip

[@philip6661]

@@ExcelForFreelancers thankyou for that works great paul

[@abdullahalmasud7839]

Thanks for this tremendous solution

[@ExcelForFreelancers]

For sure, you are very welcome, I am glad I could help.

Hi and thanks, could not make it work for my VBA Editor. I have Office 365. Any suggestions?

[@ExcelForFreelancers]

Hi and thanks will work on any desktop version of Excel, but not in the browser. I hope this helps and thanks so much.

@@ExcelForFreelancers Thank you for the answer. It works in all other programs but not in the VBA editor.

[@ExcelForFreelancers]

VBA Editors are the same regardless for the most part however Mac's and other language packs handle things a bit differently. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@jeleeloladimeji7286]

Amazing Stuffs! I love the Auto Macro.....Thanks Randy

[@ExcelForFreelancers]

Thanks so much Jeleel, much appreciated.

[@ganeshs1360]

Maybe you could make a video on Regular expression in VBA and automate web scraping in VBA. Thanks in advance

[@ExcelForFreelancers]

Hi and thanks so much. I will do my best and add it to my list.

[@munrovanheerden8462]

Hi Randy, thanks for your weekly vids - I have been following you for a number of months and have learnt a lot of new things. Unfortunately, being from South Africa (Dollar Rand exchange rate puts it outside my financial capabilities), I cannot afford your mentor-ship program, though I would love to. Again, thanks for your vids.

[@ExcelForFreelancers]

Hi Munro thanks so much for the comment. I do understand about the conversion of course so no problem. I am looking forward to creating great new training videos for you each week. Thank you for your Likes, Shares & Comments. It really helps.

[@nammarcr33737]

I really excited to learn vba

[@ExcelForFreelancers]

Thanks so much. This training will help you speed up your learning. There is a free VBA course on my site here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

[@tobayekaina8610]

Hi Randy thanks for sharing. Can't wait to see

[@ExcelForFreelancers]

You bet Tobaye, this one is a short training and covers two different solutions.

[@edgarenriquemujica1230]

EXCELlent, thanks for sharing.

[@ExcelForFreelancers]

Thanks so much Edgar, I am happy to help and share.

[@patitoshore]

Hi, should there be a link to the Autohotkey script for Excel here?

[@ExcelForFreelancers]

Hi and thanks so much. The workbook is packaged with the script (i believe) so when you download the workbook, it will also come with the ahk script. I hope this helps and thanks so much.

[@PankajYande]

Is there any external VBA editor for Excel as VBA does not support Unicode Fonts? I want to use some Unicode fonts in VBA. Is this possible or not?

[@ExcelForFreelancers]

Hi and thanks, You an add and update the fonts in your application then change the fonts in the VBA Editor > Tools > Options > Editor Format then set the font. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@wandererdark4269]

Dear sir, can you make a video about creat a Userform like Userform Buider? It look very nice and userful

[@ExcelForFreelancers]

Hi and thanks so much. I do have that already right here: kzbin.info/www/bejne/l3y5Zqabj9KceNU Thanks so much.

[@wandererdark4269]

@@ExcelForFreelancers Dear sir, like at 19:28, the "Controls" view can add new textbox line or remove it, this is the first time I see an Userform with multi line like that. Awesome :D

[@ExcelForFreelancers]

Thanks for the comment. This is a really amazing application. I love it as well.

[@jeannieramirez3494]

Randy what version of auto excel do i get there three versions?

[@ExcelForFreelancers]

Hi Jeannie, this will work with any version of Excel so its not an issue.

[@gwhittaker]

Thanks again, Randy!

[@ExcelForFreelancers]

For sure, you are very welcome, I am happy to help.

[@ganeshs1360]

What else to say? Just awesome!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@babsman4u]

I won't miss it for anything.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Emmauel.

[@farji2008]

I love to learn vba Excel.

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Farzan

[@muychamnan9993]

Hello Sir. I want to know how to add auto id in form. Would you like to show me please?

[@ExcelForFreelancers]

Hi and thanks for your comment Muy. As long as your ID # are all numerical you can assign a new ID using a named range and the Max function in VBA or in a cell using Max(IdNumb)+1 or in VBA application.WorksheetFunction.Max(IDNumb) + 1 i hope this helps and thanks

[@muychamnan9993]

Thank you

[@michaelfranks2040]

Which paid version of AutoMacro are you using in the video? I have the Developer version but do not see "Automation" in the "Functions" dropdown menu. Reference to where you create a Word document around 13:39 minutes into the video. Also, thanks for the video and for sharing.

[@ExcelForFreelancers]

Hi thanks I am using the Developer version as well. You may want to email Steve at Automate Excel and ask him how to release these features in your version Michael. Thanks so much.

[@michaelfranks2040]

@@ExcelForFreelancers Thanks, I'll give it a try.

[@complex58]

Fantastic!!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@mdsaiful6294]

Good video

[@ExcelForFreelancers]

Thank you for your Likes, Shares & Comments. It really helps.

[@PiyushMedicalKnowledge]

We're awesome this is what I want a very long time I really hope this is something something great a great wonderful thing this is something new which I can't I can't found anywhere else thanks a lot in advance for such a beautiful activity in Excel

[@ExcelForFreelancers]

For sure, you are very welcome, I am happy to help.

[@truthbespokentwicetruthbes9918]

it shows autohotkey downloaded file as IDP.HEUR.26 virus by my antivirus and is quarantined. is it safe?

[@ExcelForFreelancers]

I have been using AutoHotkey for more than 10 years. It is very safe. Make sure you are downloading it from the main site here www.autohotkey.com/ I hope this helps and thanks so much.

[@simoncrawley7430]

This would be a great presentation...at half the speed.

[@ExcelForFreelancers]

Thanks so much Simon. Yes its a bit quick but I am glad you were able to get a lot of value from it.

[@truthbespokentwicetruthbes9918]

iam not able to add the free automacro addon in the vba. It shows only 3 drop down list "code", "VBA tutorial", "Get VBA help" not all these drop down lists that you show in the VBA in this video. Can you please help with what the reason for that could be, i would happily pay for this or any other addons if it is required but could i atleast need to know if ill be able to install it correctly in my vba. Thanks in advance. also if you could make or share a video dedicated solely for the simple installation of these 2 tools it would be great and helpful for others aswell who feel anxious before buying or using it. I followed every step as given in tutorial btw exactly still no success in showing all the drop down list formulas as you show

[@ExcelForFreelancers]

Hi and thanks, can you reach out to the Add-in Developer, Steve, at this email, he will be able to guide you more clearly then I can and if there are any issues as well: [e-mail] I hope this helps and thanks so much.

[@culea0alex]

TY

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help and share

[@zvit]

I don't see a link to Automate Excel in the discription.

[@ExcelForFreelancers]

Hi and thanks. it is the 2nd line in the description that says GET THE AUTOMATE VBA PROGRAM HERE ► bit.ly/AutoMacroAddIn I hope this helps and thanks so much.

[@bearbear5353]

Unable to download excel workbook to my gmail account. Please help.

[@ExcelForFreelancers]

Hi and thanks please try to copy and paste the link in Firefox or Microsoft Edge, Chrome has been having issues. If you have tried to download this workbook using the links but had a problem please email [e-mail] . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

[@amrutchitragar3014]

Waiting sir

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Amrut.

[@AjayKumar-iu2uj]

Looking interesting

[@ExcelForFreelancers]

Thank you very much. I hope you enjoy it.

[@petermalmuo7343]

Please how do i protect my vba codes, beside using a password?

[@ExcelForFreelancers]

Hi and thanks you can check out xlspadlock. This is a great application to secure your VBA code.

[@ianhenderson1974]

tried to download on 2 different e mail addresses . nothing arrived

[@ExcelForFreelancers]

Hi Ian If you have tried to download this workbook using the links but had a problem please email [e-mail] . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

[@saddamskst2]

And is this absolutely free or there is any hidden charges

[@ExcelForFreelancers]

Hi there are two solutions discussed in this, one is free, one is paid :)

[@saddamskst2]

Sir i have check that site automateexcel. Com and thats all feature are paid So please create similar than that one it should be very best and i know that only you are the great person who can do this thing.

[@ExcelForFreelancers]

Hi thanks in the video I show you two options, one is free one is paid. Thank you.

[@dsoukeur]

thank's

[@ExcelForFreelancers]

For sure, you are very welcome

[@stumiles86]

Who's thumb downed this video already?! It's not even live yet!

[@ExcelForFreelancers]

LOL. I think some people click the link and expect it to be live already. Then when its not they are not happy? Just a guess, but thanks so much.

[@pankilpatel9244]

Interesting...

[@ExcelForFreelancers]

Thanks so much, I am glad you enjoyed it.

[@reuvlog3211]

where is script forAHK you made..???

[@ExcelForFreelancers]

Hi Reu, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

[@mornekuhn]

@@ExcelForFreelancers Hi Randy, I downloaded the workbook via my email but do not see the AHK script anywhere.

[@dougrobinson2024]

Another really great macros program is from www.macros.com. Not free, but very powerful and the pro version lets you compile the macro into an .EXE file, so others can run it without having the macro program! Check out that webpage and look for "Macro Express Pro 6". (No, I don't have anything to do with the company, not an affiliate either. I've just been using this same idea for many, many years and it's a lifesaver.)

[@ExcelForFreelancers]

Thanks so much for the feedback and information. I will check it out Doug. Much apprecaited.