Category: Excel

Using getSize with RibbonX buttons

A friend just asked for some help with making a getSize callback work with some buttons. I figured this should be an easy one, and dove into the RibbonX book to check the table on page 172. Aha! There it

Read More »

Find and Replace Dreams

Is it just me, or if the Find and Replace tool in Excel (actually in Office) really limited? The first deficiency is that I want to be able to select "Within Selection", not within "Sheet". I know that it defaults

Read More »

PED 2nd Edition – Hello World!

As I mentioned in this post, I started working my way through the .NET Hello World example in PED 2nd Edition. I ran into a funny issue though, where it kept opening up my application in Excel 2003 instead of

Read More »

VBA IDE vs VS2008 IDE

On Friday night, I began reading my way through PED 2nd Edition. After something weird happened with Excel, (I think because I have Excel 2003 and 2007 installed,) I got the bright idea to create a very simple Windows Forms

Read More »

Breaking text to two lines

I was working on my budget package today, and decided that I wanted to break the text so that it showed on two lines. For many novice users this means that they put one or two words in one cell,

Read More »