Problem with date in Combo Box

  • Thread starter Thread starter codytheretriever
  • Start date Start date
C

codytheretriever

Real dummy needs help:

Have a form with a combo box whose source is a worksheet
column of specific dates which are in the format mm/dd/yy.

When you click on the combo box on the form you see a
listing of the dates and they are shown in the format
mm/dd/yy.

When you select the date you want, the value that
shows as the selected date is suddenly in decimal format,
37930.

Have the same problem with another combo box that is used
to select time values.

What do I need to do to get the selected value in the
combo boxes to retain the format they started with?

What code statements, and where do I put them, to resolve
what I am sure is an easy fix for most of you folks?

Any help greatly appreciated!
 
Cody,

you don't need to script or code anything, just format your cell as having a
date format rather than a number format. Go to Format-->Cell and select the
appropriate format under Date.

HTH,
Katherine
 
Back
Top