Author Archives: Colin Legg

About Colin Legg

RAD Developer Microsoft MVP - Excel 2009 - 2014

Workbook_Open vs. Auto_Open

Posted on December 5, 2016 by Colin Legg

I’ve seen it written that Auto_Open() was superseded by Workbook_Open() and that it is therefore redundant and only still available for backward compatibility. In fact, there are subtle differences between the two which means that, in my opinion, Auto_Open() remains a … Continue reading →

Posted in Microsoft Excel | Tagged , | 2 Comments

My First Custom Ribbon Using Excel-DNA And Visual Studio

Posted on November 7, 2016 by Colin Legg

For the next instalment in this “getting started with Excel-DNA for VBA’ers ” mini-series I’m going to have a look at customisation of the Office ribbon. The end goal of this post is very simple: a custom tab with a button which shows … Continue reading →

Posted in Excel-DNA, Microsoft Excel, Visual C# | Tagged , , | 4 Comments

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

My First C#.Net UDF Using Excel-DNA And Visual Studio

Posted on September 7, 2016 by Colin Legg

Having recently blogged about the importance of broadening my programming horizon, I felt it was high time I put together a step-by-step guide on how to create an Excel UDF in Visual Studio using Excel-DNA. In this post I’m specifically targeting … Continue reading →

Posted in Excel-DNA, Microsoft Excel, Visual C# | Tagged , , , , | 6 Comments

Who Has My Workbook Open? [VBA]

Posted on July 31, 2016 by Colin Legg

A while back I posted some C# code which would find out if someone is locking an Excel workbook and identify who they are. At the time I didn’t post a VBA equivalent because I had linked to a VBA … Continue reading →

Posted in Microsoft Excel | 3 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

UK Has Its Pie And Eats It

Posted on June 27, 2016 by Colin Legg

Here are the Brexit vote results displayed using the doughnut chart style which seems to have been popular on some of the media websites. And here are exactly the same numbers displayed using our old favourite: the 3D pie chart.

Posted in Microsoft Excel | 5 Comments

Getting A Handle On Userforms [VBA]

Posted on May 6, 2016 by Colin Legg

In a previous post I wrote about how to add minimize and maximize buttons to a VBA userform. A necessary part of that process is to get the handle to the userform’s window, but the focus of that post was … Continue reading →

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