What is xlWings and Why Use it? XLWings is a python framework that allows you to combine the power of Excel, VBA and Python. It allows you to make Python massively useful for your workflow, especially if you're new to Python. This is because you can use Excel to display the results of your Python programs in the manner that you're most comfortable with, i.e. Spreadsheets and … [Read more...] about XLWings Python For Excel Tutorial
Programming
How To Create Custom Excel VBA Events
What are custom events and why use them ? Custom Events Are Messages Custom events are messages that your program can broadcast to other objects in your application. They have the advantage of being massively flexible, because other objects can choose to react to or ignore these events depending on how you've programmed them. Custom events help simplify your … [Read more...] about How To Create Custom Excel VBA Events
How To Enable The Developer Option In Excel
In this quick tutorial I'll show you how to Enable the Developer Option In Microsoft Excel. Do you need the Developer Option Enabled? Firstly it's worth asking if you need the developer enabled for what you want to do? You don't need to have the "Developer" option enabled if you just want to get into the VBA Editor. If that's all you want to do, pressing the "Alt" key and … [Read more...] about How To Enable The Developer Option In Excel
Excel VBA MsgBox – Ultimate Tutorial
Msgbox allows you to communicate information to your user or request guidance on the next action that you'd like them to take. MsgBox can take up to 5 arguments, the message being the only one that's mandatory. Bear in mind that the message box is disruptive, meaning it halts processing until the user takes action such as pressing return or clicking … [Read more...] about Excel VBA MsgBox – Ultimate Tutorial
Understanding The Excel Advanced Filter
Background The Excel Advanced Filter gives you database like functionality and helps you crunch large datasets with ease it can also help you begin to better understand database structure. This article contains several tutorial videos related to the Advanced Filter, enjoy... Unlike the Autofilter which only allows you to filter on one element per column, the … [Read more...] about Understanding The Excel Advanced Filter