View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bob leathers bob leathers is offline
external usenet poster
 
Posts: 7
Default Combo Box Display

Hello Folks

Using VB 6.3
I have a combo box in a user for for selecting certain dates from the
spreadsheet. The drop down works ok, but when I select a date the
information displayed in the window is not the date.

For instance I select 02/09/07 and the displayed value is 39122.
How do I get the window to display 02/09/07 as opposed to 39122.

I have the same problem with a time combo box.

Thanks for your help