How-To Geek on MSN

5 more Excel VBA toolbar shortcuts that work in every spreadsheet I open

These reusable shortcuts handle pasting, navigation, cleanup, indexing, and timestamps from any standard Excel workbook.
How-To Geek on MSN

I built my own Excel toolbar using basic VBA, and it works in every spreadsheet I open

VBA may have a bad reputation, but it's still one of the most effective ways to automate repetitive actions in standard XLSX workbooks.
note

[Excel VBA] How to automatically export a list of macro names in a module to a sheet

As your VBA projects grow larger, do you ever find it difficult to grasp the overall picture when dozens of macros are packed into a single module, leaving you wondering, "Wait, what names did I give ...
GitHub

EitaroSeta/excel-vba-sync

EXCEL VBA module Sync は、開いているExcel の VBA モジュールを VSCode 上で編集するための拡張機能です。 VBA モジュールのVSCodeへのエクスポート、VSCodeで編集した内容のVBAへのインポートが行えます。