View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James[_14_] James[_14_] is offline
external usenet poster
 
Posts: 25
Default dates in dropdown

I would like my user to pick a date from a dropdown
combobox of 30 days. a15=today(), a14=a15-1, a16=a15+1,
etc. This gives me a nice list of current dates. The
problem is when I pick a date, the format in the dropdown
box changes to a number. The dates look fine in my
dropdown but when I select one I lose my formatting and
only have a number showing. THIA for any suggestions!
James

James at Landiscomputer.com