by Paul Kelly | May 26, 2025 | Uncategorized
Previously in VBA it was difficult to Sort an array. You had to write your own sort function or copy the data to the worksheet and sort it there. Neither method was ideal. But since Excel 2021 and 365 there is a new Worksheet Sort function which we can use to sort our...
by Paul Kelly | | Data Structures VBA, Vault Video
Webinar Number: W0066 Arrays are possibly the most important element of Excel VBA. Not only do they make your code more readable, they also allow you to process data thousands of times faster than using Ranges. If you haven’t used arrays before, then they...
by Paul Kelly | Apr 28, 2025 | UserForms
What is the Modern VBA ListBox The ListBox is a control commonly used in VBA UserForms to create user interface-based applications. While it’s functional, the standard VBA ListBox dates back to the 1990s and lacks the advanced features found in modern web-based...
by Paul Kelly | | Building Applications, Vault Video
Webinar Number: W0065 This webinar features: Learn a system for building Excel VBA applications. How anyone can get started creating an Excel VBA application How to easily design your application without the need for complex tools or methods A technique for testing...
by Paul Kelly | | Building Applications, Vault Video
Webinar Number: W0064 Date: 28/8/2024 here to join webinar Description Mastering the VBA Dictionary: Proven Techniques for Efficient Coding In this webinar, you’ll learn proven techniques to effectively use VBA Dictionaries, enabling you to streamline your...
