Excel Tips

Excel 97 introduced new User Forms. In English, teach me how to create and use a list box. »

January 17, 1999

Like many of you, I started writing Excel macros in Excel 5.0. This whole Macro Editor in Excel 97 is a bit intimidating. For this week's tip, I will show you, step by step, how to create the list box for this project. The focus this week is just on the combo box.

Convert Excel Days To Months »

November 21, 1998

I want to use an Excel pivottable to summarize the data, but I want to see it at the month level instead of at the daily level.