How to Use VBA

How to Use VBA

Create a Workbook Table of Contents

I put off learning VBA for a long time.

Like 10 years long.

But I'm finally coming around. And it's pretty excellent.

Not to mention that learning is supercharged with all the LLM tooling available to instantly help me debug things.

Below is the little project that I cooked up.

I've got video as well as a fuller article over on my newsletter here.

Video Walkthrough

Free Newsletter

I haven't posted anything via LinkedIn's newsletter feature in a long time. However, I just realized there are 1,600+ people subscribed to this thing. ??

Do me a favor:

If you're interested in getting good at spreadsheets and automating your online business with software, head over to the newsletter that I actually do update: https://www.gotsheet.xyz/subscribe


Tom Hinkle

Good at Excel? ... I'll make you better. Just starting out? ... I got you. Excel | SQL | Tableau | Power BI Training | Consulting "Lets get this done!"

2 个月

Love to see these vba posts Eamonn. There’s still a lot of life there

要查看或添加评论,请登录

Eamonn Cottrell的更多文章

  • How to Use the IF function

    How to Use the IF function

    Don't let your spreadsheet intimidate you. We’re all familiar with the logic behind IF().

  • Apps Script Form Submission to Google Calendar

    Apps Script Form Submission to Google Calendar

    Since last we spoke I’ve… Set a new personal marathon record (3:14:30) Played some old school Zelda with my kids (SNES)…

    4 条评论
  • 6 Ways to Number in Excel

    6 Ways to Number in Excel

    Since last we spoke I’ve been recording several new long and short form videos. Check out the YouTube Channel if you…

  • Sort in a Cell

    Sort in a Cell

    Get these handy tips in your email by subscribing to my free newsletter at https://got-sheet.beehiiv.

    2 条评论
  • Apps Script All Day Events

    Apps Script All Day Events

    Since last we spoke I’ve made some short videos… Microsoft table breaks mobile view Combine Excel Data onto New Lines…

    2 条评论
  • Name Those Ranges

    Name Those Ranges

    Since last we spoke… It’s snowed 7+ inches at our house! The kids are in heaven. I’ve driven to Mississippi and back…

  • Double XLOOKUP

    Double XLOOKUP

    Since last we spoke I’ve… Run my first 5K in over a decade Run a 50K Started writing a book… Now to the sheets… Double…

  • Time Zones in Google Sheets

    Time Zones in Google Sheets

    Since last we spoke I’ve… Run 40 miles up and down Boring Road Built an open source memory verse website Hung Christmas…

  • Deck the Halls With QUERIES

    Deck the Halls With QUERIES

    Hi there! Since we last spoke I've Run a couple half marathons (of my own making) Analyzed a collectible card game that…

  • Abuse Your Spreadsheet

    Abuse Your Spreadsheet

    AKA: How to use your spreadsheet to do non-financial, cool challenges. The Palindrome Challenge Since last we spoke…

社区洞察

其他会员也浏览了