Excel proficiency is a must-have for students entering any field. But let’s be honest: learning spreadsheets doesn’t have to be a drag, although it can feel that way sometimes. That’s why I have ...

But there are signs of new life in the VB ecosystem, most recently on the Visual Basic for Applications (VBA) side of things. This week saw a couple of improvements to Rubberduck, a project to upgrade ...

Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code. With both methods, users click a ...

If you want to enable or disable Trust access to Visual Basic Project in Office apps, such as Word, Excel, PowerPoint, etc., you can do so with the help of the in-built option, Local Group Policy ...

The questions plaguing users of Microsoft Excel—JavaScript support, slow Mac development cycles, the lack of Easter eggs—all apparently come down to one thing: prioritizing developer resources. The ...

In this space, I typically write about tools that help you build, manage, test or deploy software development projects. The one part of the project I've mostly ignored thus far is perhaps the most ...

One of the handiest things you can do with Visual Basic for Applications (VBA) in Office 2011 is to share data between two different Office apps. For example, let’s say you want to embed data from ...