Category: VBA Hacks

Vagaries of the Characters() Method In Excel 2010, version 14, the Characters method of Shapes did not, and in newer versions may still not, build and return a character object containing expected property values. The good news: No deficiencies were identified when working with cell contents. With Comments Two issues were observed when argument parameters… Continue reading VBA Characters Method Bugs: Comments vs TextBoxes

Has Excel ever moved or resized comments for you? Would you like to be able to reset to default position, and resize all existing comment boxes to fit the size of your comments? Here is an Excel add In that allows you to select a cell, range of cells, or the used area of the worksheet,… Continue reading Excel Comments Moved Resized Bug

Quick Start to adding a ribbon group and buttons, and underlying code to become an excel 2010 add-in. Create an empty folder. EXCELaddins to hold your working files. Within this folder create 2 subfolders named customUI and _rels. Open a new blank workbook. Open the Visual Basic Editor (VBE), try Alt + F11. Create your… Continue reading Customizing Excel Ribbon