Professional Advice from the Excel VBA Trenches
Joined January 2015
- Tweets 267
- Following 818
- Followers 864
- Likes 140
158 Photos and videos
1 Dec 2023
If you want to improve your Excel VBA Code then check out my latest video where I audit 3 real-world applications...
#ExcelVBA #VBA shorturl.at/lqyV1
192
8 Jun 2023
Brand new video: How to Create Add-To-Cart Animation in VBA youtu.be/YNJK_b9xoWY
#VBA #ExcelVBA #UserForms
1
241
27 Mar 2023
Live VBA webinar this week! How to Create Powerful Data Queries using Excel VBA.
Register here: attendee.gotowebinar.com/reg…
#ExcelVBA #VBA #Excel
2
215
13 Mar 2023
In my latest video I show how to use the GetOpenFilename() function to allow users to select a file or multiple files.
I also cover how to copy data from these files and how to write optimal the code to do optimize the performance. youtu.be/dQB2LYCw0Ko
#ExcelVBA
1
209
1 Feb 2023
My latest video covers the little-known but incredibly
useful Enums.
"Enums: The Key to Cleaner, More Efficient VBA Code"
Video Link: youtu.be/Kxeqydve-CM
#VBA #ExcelVBA #VBAEnums
1
2
219
23 Jan 2023
Can ChatGPT help you write better VBA code?
Check out my latest video and find out. Link in the comments below 👇 #ChatGPTVBA #ExcelVBA #ChatGPTExcel
1
1
2
609
14 Dec 2022
Watch these 28 minutes if you want to become an Advanced VBA user! youtu.be/cUB-MYTlDUU
#ExcelVBA #AdvancedVBA
1
23 Sep 2022
My first video on Power Query has just been published. Check it out here: youtu.be/hsBKyM4HMyA
#VBA #Excel #ExcelVBA #PowerQuery
5
9 Sep 2022
Video link: youtu.be/mfG74mJr_8g
Brand new video "How to Combine Multiple Excel Files using VBA".
If you need to read data from multiple files using VBA then you cannot afford to miss this video.
#Excel #ExcelVBA
2
26 Aug 2022
20 Jul 2022
2
24 May 2022
My latest video covers everything you need to know about VBA Arrays in 3 minutes.
Long videos have their place but sometimes you want all the info quickly:-)
youtu.be/vDn5OpH0y6Y #VBA #ExcelVBA
1
1
20 Oct 2021
Check out my latest video on using Web APIs with VBA.
You can download working examples and a quick start template from the description below the video.
youtu.be/KZeYKZJzQIk
#ExcelVBA #ExcelWebAPI #VBAAPIData
1
4
18 Aug 2021
My latest video provides a step-by-step guide to building
a modern style data entry form.
#excelvba #vba #userform
youtu.be/nsClitREZqg
3
17 Jul 2021
2
Paul Kelly retweeted
29 Jun 2021
What a great start to the day when you realize that Paul Kelly, whose quality material on excelmacromastery.com taught me VBA, published a video about Python vs VBA, featuring my own project @xlwingsorg! #python #excel #xlwings
29 Jun 2021
2
1
13
29 Jun 2021
2
2 Jun 2021
5 VBA Hacks Everyone Should Know!
Free live webinar this week. Sign up here: bit.ly/3g5Vz3R
#vba #excelvba #excel
Paul Kelly retweeted
20 May 2021
We're celebrating the 30th birthday of Visual BASIC, aka "The perfect user programming environment for the 1990s"
#VisualBasicIs30
#ThrowbackThursday
#VB
3
15
46