The site formerly known as Code For Excel and Outlook
February 3, 2010 by · 
In the previous post I showed a simple sub for listing most of the CommandBar properties. But we can also return this information using a function.
You might do this (in Excel versions prior to 2007) when working with a command bar and need to view its properties before making a change. Here is a function that returns a string array of properties for each Command Bar Object.
Continue Reading: Return Command bar info in a VBA function »
February 1, 2010 by · If you work with Command Bars in Excel, or write add-ins for Excel 2003 that add custom menu options, you'll need to know various properties such as their names. A basic subroutine would look like this:
Continue Reading: List all Command Bar Properties in Excel »
January 22, 2010 by · 
In Return value if in range in excel, Oscar shows us a formula for returning values in a column based on a number range. Let's review his formula and also provide a few more that can do the same thing simpler.
Continue Reading: Getting an approximate match from a range »
Site last updated: February 8, 2012
Follow Me