Tag Archives: VBA

Get Property Syntax Bug [VBA]

Posted on October 17, 2016 by Colin Legg

I just saw this posted by @RubberduckVBA  on Twitter and couldn’t resist sharing it on here. Did you know that this VBA code will compile and run correctly? And, perhaps even scarier, so will these (and variations thereof):

Posted in Microsoft Excel | Tagged , , | 2 Comments

Excel Development Roadmap – Where Next?

Posted on July 9, 2016 by Colin Legg

The developer tool suite offered by Microsoft for Excel is currently a set of three complimentary technologies: Visual Studio Tools for Office (Dot Net) Apps for Office (Javascript) Visual Basic For Applications The VBA language is an interesting one. Often referred to … Continue reading →

Posted in .Net, Microsoft Excel, Visual C# | Tagged , , , | 6 Comments

Unwanted Worksheet Events? Maybe SpecialCells() Is To Blame!

Posted on March 6, 2016 by Colin Legg

I’ve written a lot on this blog about Range.SpecialCells() and how careful you have to be when using it. Here’s yet another caveat which I didn’t know about until another developer brought it to my attention. Put some data in a worksheet … Continue reading →

Posted in Microsoft Excel | Tagged , , , , , , , , , , , | 4 Comments

Deceptive Appearances: MSForms Textboxes And Comboboxes

Posted on August 29, 2015 by Colin Legg

The Microsoft Forms 2.0 Object Library (FM20.dll) really lacks a number of controls. One which I seem to miss the most often is a “grid” control which will let users select rows and edit data in multiple columns. For this sort of … Continue reading →

Posted in Microsoft Excel | Tagged , , , , , , , , , , , | 2 Comments

Is Your Cell Blank Or Empty?

Posted on October 31, 2014 by Colin Legg

Two pet peeves of mine are the way the terms [unique and distinct] and [empty and blank] are interchangeably used in Excel. They have different meanings so it’s really confusing when the name of a function or utility suggests it … Continue reading →

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , | 8 Comments

Excel Macro to Find and Calculate Precedents

Posted on April 6, 2014 by Colin Legg

Today’s Guest Author Kintaar is the editor of Math for Mere Mortals, a blog about numerical calculations and programming for those of us who are not godlike experts. He writes about a variety of topics in the areas of financial … Continue reading →

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , | 7 Comments

VBA: Four Ways To Change Variable Values In Break Mode

Posted on February 22, 2014 by Colin Legg

Zack’s recent post over at Excel & Access Experts got me thinking: how many ways are there to change a variable’s value in break mode? Needing no further excuses to give Cropper a try, here’s what I came up with. … Continue reading →

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , | 2 Comments

A Guided Tour Through The VBA IDE’s Options

Posted on February 17, 2014 by Colin Legg

The VBA Integrated Development Environment provides a limited set of options under Tools > Options which will let you customise the environment for your own personal needs. Microsoft hasn’t added anything new to this part of MS Office for many years … Continue reading →

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , , , , , , | 8 Comments