Userform with drop down box displaying Date in incorrect format

All,

I have a userform with a dropdown box allowing the user to select from a range of dates. The dates are on a sheet with in the workbook and I have created a "Name" range for the range of dates. The userform then uses this name as the rowsource. These dates are generated using "=today()+x" where x is actually a number ranging from 1 to 28, i.e., tomorrow to 4 weeks from today. Anyways, the drop down box allows the user to select from these range of dates with a format mm/dd/yyyy, however when a date is selected it converts to the numerical value of the date. Below is my code from the userform.

Please Login or Register  to view this content.