View Single Post
 
Old 08-26-2011, 07:54 AM
flackend flackend is offline Windows XP Office 2003
Novice
 
Join Date: Aug 2011
Posts: 6
flackend is on a distinguished road
Question Automatically select first item in drop-down?

Is there a way to have the first item in a data validation drop-down list automatically selected?

I have a workbook set up with dependent lists data validation. So I enter the first cells data, 5:30 PM. The second cell's data validation is always the first cell's time + two hours. Instead of clicking the drop-down list and selecting the only option, 7:30 PM, is there a way to have the value selected automatically?

Thanks!
Reply With Quote