Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Macro Printing One Sheet with one change at a time | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
List boxes/combo boxes | Excel Programming |