Do you write Excel macro, with VBA programming? Is your code clean?
Clean Code Wristband
While I was browsing the Internet recently, I saw someone promoting a “Clean Code” wristband, with donations going to a non-profit group.
Writing clean code is an idea worth supporting, and you could snap that wristband, to wake yourself up, if your coding starts to go off track.
Excel VBA Tutorials
If you’d like to get started with Excel VBA programming, there are several pages on my Contextures site, where you can find tutorials, sample files, and videos.
1 — How to Add Macro Code to Excel Workbook — How to copy Excel macro VBA code to your workbook, from website or sample file. Different types of code, where to paste it. Step-by-step videos, written steps
2 — Excel Macro to Save Sheets As PDF — Excel macro saves active sheet or sheets in PDF format, prompts for file name and folder. See macro code, get sample workbook with macro.
3 — How to Create Excel UserForm for Data Entry — See how to create an Excel UserForm for data entry, with text boxes and buttons. Follow step-by-step videos, detailed notes with screen shots, free Excel workbook
4 — Excel ComboBox Lists for Easy Data Entry — How to use an Excel ComboBox with a drop down list to make data entry easy in an Excel UserForm
Video: Record and Run Excel Macros
If you’re just getting started with Excel macros, this 5-minute video shows you the basic steps.
There are written steps, and an Excel workbook to download, on the Record and Test an Excel Macro page, on my Contextures site.
_______________________