Tag Archives: VBA

Get Property Syntax Bug [VBA]

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): Advertisements

Posted in Microsoft Excel | Tagged , , | 2 Comments

Excel Development Roadmap – Where Next?

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!

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 , , , , , , , , , , , | 3 Comments

Deceptive Appearances: MSForms Textboxes And Comboboxes

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?

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 , , , , , , , , | 6 Comments

Excel Macro to Find and Calculate Precedents

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 , , , , , | 6 Comments

VBA: Four Ways To Change Variable Values In Break Mode

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

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