I published a tutorial about Using RefEdit Controls in Excel Dialogs, which showed how to use these helpful range-selection controls in Excel UserForms. Then I wrote about an Unspecified but Painfully Frustrating Error that seemed more often than not associated with RefEdit controls. This and other RefEdit problems skyrocketed as users of my commercial utilities upgraded [...]

The report you submitted at the end of last year was well received. Your brilliant analysis was backed up by informative charts. Your boss, his boss, and the shareholders were all very impressed. Now you have to update the chart to show year to date information, but you don’t want to generate all new charts. [...]

A quick post today to respond to a user of my Quick XY Chart Utility. This noncommercial utility generates XY charts using input data in a variety of layouts, beyond X in first column and Y in subsequent columns. The utility does not apply any particular formatting to the output charts, using the defaults it [...]

I recently wrote about Using RefEdit Controls in Excel Dialogs. I use(d) them a lot, and they are a handy way on a dialog to get a range that the user wants a procedure to use. These controls are prone to incompatibility issues between versions of Excel, particularly between Classic Excel (up to 2003) and [...]

This is the sixth of nine installments in the Build an Excel Add-In series. In previous installments, we wrote some code to perform a useful task, enhanced its functionality to make it more broadly applicable, modularized the code and included an auxiliary modular procedure, built a dialog to ask the user for preferences, and brought [...]

You have a chart that you make every week or every month, and you’re tired of making it from scratch every time. So you record a macro to automate the process. When you run the macro to make your chart the next time, you get no chart. Instead you get an ugly error message.