When you're setting up a Microsoft Excel spreadsheet that contains date information, you'll speed your task if you let Excel do the tedious work of filling in columns of individual date entries.

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.