- Home
- |
- Author: Marcus
Replacing VBA with Excel’s Dynamic Array Formulas
Why use VBA when Excel's Dynamic Array Formulas do the heavy–lifting for you?...I’ve been working on a small Excel project for a large FMCG (Fast Moving Consumer Goods)
Checkboxes on UserForms
How to create attractive checkboxes for Excel and Word UserFormsCustom vs. Native CheckboxI love UserForms, really I do. I develop a lot of add-ins for both Excel and
Power Query Blows Away 29 Years of VBA Data Access
As an Excel VBA developer in the corporate world, you spend a lot of time simply shuffling data around.Pull data from a database here.Send it to a database
How To Share Excel Data in a Small Team
The benefits of keeping your data in a separate workbook from your reports and processes.Separation of ConcernsIn a previous post we spoke about the benefits of keeping your
How to Create Option Buttons in Excel
How to let your Excel users select one item with custom option buttonsBy now, you’re probably familiar with Excel’s checkboxes.From the Insert ribbon tab, select Checkbox, apply a
How to Create Single Select Checkboxes in Excel
How to make Excel checkboxes work like option buttonsCustom Checkboxes in ExcelSome time ago – pre “in-cell” checkboxes in Excel – I needed to provide a way for
3-Tier Architecture in Excel
There’s an old Excel aphorism that says, “Excel’s greatest strength is its flexibility and its greatest weakness is its flexibility.”One result of this flexibility is that far too
Viewing Word Documents in Excel
Dynamically viewing Word Documents in Excel with a UserForm to expand the functionality of your Excel solutions.Embedding Applications in ApplicationsYears ago I developed an Access database to manage
Dynamically Filter a List in a Worksheet
When Data Validation or UserForms just won’t cut it in Excel.Filtering Lists Options in ExcelIf you use Data Validation in Excel, you’ll know it improves the data quality