hi,
39122 is the date number for 2/9/07.
in your code you need to pre-format the cell to date. it should display date
then.

Regards
FSt1

"bob leathers" wrote:

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