Excel: Data validation automatically set to first item in list

Morning sirs, I've been having a good look around for this, but am struggling to find a solution that works. I have various data validation lists, and would like them automatically to be set to their first value when they are set up (uses a macro). Does anyone have any idea how this might be done? Thanks in advance, dirtychinchilla

This question generated 45 answers. To proceed to the answers, click here.

This thread is current as of November 27, 2013.

For more resources for Microsoft Excel