Format Dates in Control Combo Box

[ExcelJen]

I have a combo box set up to select from a list of
several different dates. When you click the arrow to
select a date, the dates are formatted properly like in
the list, (2/9/04). But when you select your date, it
shows up as the excel code for the date. (38026).

Any idea how I can get the selected date to show as in
the list 2/9/04??

I have looked through the properties window and can't
figure it out.

Thank you!

 

[Bob Phillips]

Jen,

Where does it go. If a worksheet range, format that cell, even in VBA

Range("A1").NumberFormat = "d/m/yy"

If it goes asd text somehere, format that, like so

Format(Combobox1.Value,"d/m/yy")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[ExcelJen]

Bob -
I am not trying to format the linked output cell, I am
trying to format the combo box itself.
So when you select a date in the combo box, what you see
in the combo box is the date, not an excel code for that
date. ????

 

[Bob Phillips]

Is it being added, if so then

.Additem Format(myDate,"d/m/yy")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)