View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Matt[_33_] Matt[_33_] is offline
external usenet poster
 
Posts: 78
Default Combobox / Data Problems



What goes back to the mm/dd/yyyy hh:mm format?


The dates in the drop down menu have the right date but they turn back
into mm/dd/yyyy hh:mm as soon as you hit enter or leave the combobox
....

You don't mean the selected item in the combobox, do you?


Yes, the date format of the combobox changes


If you put that value into a cell, maybe you can just format the cell the way
you want--either manually or in code???


Actually I use the combobox to select a date which then goes into a
different cell ... all those cells have the date format I need but in
the combobox its no cooperating :(