Format Dates in Control Combo Box

  • Thread starter Thread starter ExcelJen
  • Start date Start date
E

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!
 
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)
 
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. ????
 
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)
 
Back
Top