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 Thanks so much Arn -- fragher7 ----------------------------------------------------------------------- fragher75's Profile: http://www.excelforum.com/member.php...fo&userid=1236 View this thread: http://www.excelforum.com/showthread.php?threadid=27040 |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com