Results for:
VBA

• Simplifying data entry with a list box and VBA code

  14 Feb 2012

  To plan which topics to write during the next three months, our Office documentation team needed an easy way to enter values in an Excel worksheet limited only to values in a list. However, we couldn't use Excel's data validation feature because it only lets you select one item per cell. The solution...
• Generate invoice numbers in Excel

  12 Jan 2012

  If you need to create invoices for your business, you can use one of the many invoice templates found on Office.com. Although these templates are a great starting point, they won't automatically generate unique invoice numbers—you'll need a macro for that. Excel MVP Bill Jelen graciously offered...
• VBA tip: Limit the number of times a file can be opened

  4 Jan 2012

  Today’s VBA power tip is brought to you by guest blogger Bob Umlas . Bob is a long-time Excel MVP and author of Excel Outside the Box , from which the text below is excerpted. In addition, Bob organized the Excel User Conference , which takes place this year on March 29-30, in Atlantic City, New...
• Avoid losing the state of the global IRibbonUI ribbon object

  19 May 2011

  In today's post, Excel MVP Ron de Bruin provides a solution for a common problem that occurs when you use RibbonX and VBA to customize the ribbon. You can find more tips and links to Excel add-ins at Ron's website: http://www.rondebruin.nl/ . There is a common problem when you are working with the ribbon...
• IF and only IF (video)

  29 Mar 2011

  This post is all about IF--not the poem by Rudyard Kipling, or the 1971 hit song by Bread, but the function . The IF function is used in many Office programs, but most of us know it from Microsoft Excel: IF(logical_test, [value_if_true], [value_if_false]) IF is one of the most searched-for words on Office...
• Control slicers by using VBA

  27 Jan 2011

  Today’s author is Jan Karel Pieterse, an Excel MVP, who explains how to work with the SlicerCache object, and how customize buttons or change slicer properties by using VBA. For more information about slicers, read PivotTable Slicers on Jan Karel’s website: http://www.jkp-ads.com/ . Juggling...
• Pulling RSS data into Excel (or: Using Excel to Search Craigslist) - Part 2

  22 Oct 2010

  This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. You'll remember last time that we'd built a spreadsheet that searched Craigslist via the RSS feed that's available for search results, and pulled the information into Excel using the little-used XML Map feature...