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.
MUO on MSN

I built my own Excel function without touching VBA, and now I use it daily

If you can write an Excel formula, you can build your own function.
note

Why You Can't Write Programs Even Though You Understand Excel VBA Syntax #3

I will use a simple example to talk about how to think and proceed when you want to implement your daily work using VBA. There is data with dates in column A, deposit amounts in column B, and company ...
GitHub

Unit Testing

The Refresh command synchronizes the test methods with the code in the IDE, but if test methods are added from within the Test Explorer then the new tests will appear automatically. '@TestMethod ...
GitHub

decalage2/ViperMonkey: A VBA parser and emulation engine to analyze malicious macros.

ViperMonkey is a VBA Emulation engine written in Python, designed to analyze and deobfuscate malicious VBA Macros contained in Microsoft Office files (Word, Excel, PowerPoint, Publisher, etc). See the ...