Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox and "mmm-aa" format
arno Wrote: Hi, I have a problem with the format of value in a combobox. The range of value in the "ListFillRange" are dates (Jan-02, Feb-02 ...). When I select a value in the combobox, this value changes in serial data format (37287,37315 ....) what do you think about Private Sub ComboBox1_Change() ComboBox1.Value = Format(ComboBox1.Value, "dd.mm.yyyy") 'use whatever format you wish End Sub regards arno Excuse me, but in this way, after the selection in the linked cell, see only this year dates!!! My dates start from 2002. Bye, Francesc -- fragher7 ----------------------------------------------------------------------- fragher75's Profile: http://www.excelforum.com/member.php...fo&userid=1236 View this thread: http://www.excelforum.com/showthread.php?threadid=27040 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
ComboBox and "mmm-aa" format | Excel Programming | |||
ComboBox and "mmm-aa" format | Excel Programming | |||
Convert "Month" to "MonthName" format from db to PivotTable | Excel Programming |