EJC

It sounds like your using a combobox from the Control Toolbox (as opposed to
the Forms toolbar). It also sounds like you have elected to not print the
combobox. If all that is true, then it is the cell that is underneath that
is printing, not the value in the combobox. You should be able to format
that cell to look the same as the combobox.

To check if you are printing the combobox, go into design mode, right click
on the cb and choose Format control. The Properties tab has a checkbox for
printing.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com


EJC wrote:
I have a work hours spread sheet that has combo boxes for
start and end times within certain days. I have the combo
boxes linked to the cell behind it and populated with
hours of the day. The times show up fine when selected,
such as 6:00; when I print the sheet or use print preview,
the value in the combo box then displays 0.25 (like a
quarter of a day). I reselect the box and can repopulate
6:00. It does the same thing for dates too.

Is there code in VB that I can write that will allow these
values to be printed as times, and not as decimals?