Category: Microsoft Excel

Microsoft Excel

Excel VBA: Using .NET string.Format in Excel

The functions string.Format and StringBuilder.AppendFormat are two very usefull functions for formatting strings and increasing the readability of your .NET code. The Format function in VBA unfortunately works in a quite different way than the string.Format function in .NET. As far as I know there is no built-in function in VBA to acomplish the exactly same result as string.Format. In Excel VBA the […]

Microsoft Excel

Excel VBA: Adding custom buttons to the Right-Click popup menu

In Microsoft Excel it is possible to extend the right click popup menu by using VBA. The right click menu is implemented as a special CommandBar (like the toolbars in Excel 2003) with the name “Cell”. Customs buttons are added before the popup menu is displayed. It is up to yourself to make sure that […]

Microsoft Excel

Excel VBA: Adding custom Button to the Toolbar or Ribbon

Custom buttons are added to the toolbars or ribbons when a Microsoft Excel sheet is opened, and removed when the sheet is closed. To be notified when a given Excel sheet is loaded we need to listen to the Workbook_Open event of the ThisWorkbook object found in the VBA Project explorer. Please notice that the following code works best with […]

Microsoft Excel

Excel VBA: Displaying the Developer Toolbar or Ribbon

By default the developer toolbar or ribbon (depending on the Excel version) is hidden in Microsoft Excel. In Excel 2007 and later it can be quite tricky to figure out where to enable the developer ribbon if you don’t know where to look. To make things even worse, in Excel 2010 and Office 365 they have changed the way […]

Back To Top


Subscribe to our newsletter