Tag: vba

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 […]

Back To Top

Subscribe to our newsletter