Excel

Right Click

Right click mouse events are one of my favorite VBA features.  Following is an example of the code needed to add a right click event.  You can also download the spreadsheet. Public Sub addRightClick()        'Add Read More

posted Wednesday, November 12, 2008 10:13 AM by galimi | 0 Comments

Arrays

One of the most powerful features in Excel is the formulaic array.  Formulaic arrays allow you to process sets of data as opposed to calculating just a flat formula.  Let's say you had a list and you wanted to count the number of items in that Read More

posted Monday, November 10, 2008 5:29 PM by galimi | 0 Comments

Common

I learned how to do a For... Next... Loop when I was about 14 years old.  Over 20 years later & I am the patron saint of For... Next... Loops.  There are many variations on Loops... you've the For/For Each/Do/Do Until & While. I find Read More

posted Friday, November 07, 2008 10:09 AM by galimi | 0 Comments

Recording Macros

A client called last night wanting to programmatically set the minimum value on his Y axis for an embedded chart.  Suprisingly, I remembered most of the object property that I needed to modify, but just couldn't get it all... that's when I did what Read More

posted Wednesday, November 05, 2008 10:23 AM by galimi | 0 Comments