- Popular Topics
How to create, configure and use Form Controls and ActiveX Controls Scroll Bars in Excel 2007 and Excel 2010
Using Scroll Bars in Excel 2007 and Excel 2010 allows you to add visually appealing,easy to use and intuitive controls to your spreadsheets; users can then quickly and easily select a value using it.
How to use the COUNTIF and COUNTIFS functions in Excel 2007 and Excel 2010 to count text in a cell range. Remove Duplicates allows you to create lists of unique items from a larger data source.
How to write Visual Basic code to configure a User Interface created using a UserForm in Excel 2007 and Excel 2010
Visual Basic code allows you to configure a User Interface using a UserForm in Excel 2007 or Excel 2010. Scripts initialise the User Interface, configure the buttons and add data into the worksheet.
Guide for creating to do lists in Excel 2007 / Excel 2010 using Check boxes and Combo boxes. Use Conditional Formatting using formulas and cell values with icon sets to add visual impact to your list.
A Speedometer, Dial or Gauge chart in your Excel 2007 / 2010 spreadsheet will look impressive, especially in a dashboard. It uses a Doughnut chart and Visual Basic code to create a moving needle.