Aeternus Consulting Blog

Aeternus Consulting Blog

Hello, We are Aeternus Consulting

We like to put our tentacles into a lot of things. We teach, consult, design presentations and develop VBA applications & websites.

Blog Articles

Excel infographics for XLOOKUP Part 1

Purpose of this Excel Infographics for XLOOKUP Infographics (information + graphics) use visuals and text to highlight key information and ideas. The overall goal of infographic

Excel Infographics for VLOOKUP

This is an infographic on the Excel function VLOOKUP. VLOOKUP is a super useful function when you need to find things in a table or a range by row.

Great Art Pixelated with Excel VBA

You can create beautiful pixelated artworks with this Excel VBA application! There are creative ways to use it. Create unique avatars for Zoom meetings or WhatsApp!

Fastest Search Excel VBA Codes

In this article I set myself a challenge to write the fastest VBA codes to locate a cell in a range of 5 column by 1048576 rows (5.2 millon cells) in a worksheet. They are written to be reusable in your own Excel VBA projects.

Best Milliseconds Timer in VBA Tutorial

I will show the complete VBA codes that you can simply copy and use, I will describe the research process involved to create millisecond timers in VBA using Windows APIs so that you can deepen your understanding of using Windows APIs with VBA coding.