Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox with Dates
Use the Click event to reformat it:
Private Sub ComboBox1_Click() ComboBox1.Value = Format(ComboBox1.Value, "mm/dd/yyyy") End Sub the other alternative is to load it with code (rather than using the listfillrange property) and load it with string values representing the dates. -- Regards, Tom Ogilvy "mxinter" wrote in message ... Hi Guys, Im adding a Combobox into a spreadsheet that has a dropdown with several dates. When the date is selected, it automatically changes that date into a "text" format. For instance the user selects 19-Sept and the window shows "37883" after being selected instead of "19- Sept".....can someone help me figure out....how to change the format.....or a workaround. Thx all the way down from Mexico, mxinter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - How to get cell referrences from dates in combobox | Excel Discussion (Misc queries) | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
ComboBox value? | Excel Discussion (Misc queries) | |||
combobox value | Excel Discussion (Misc queries) | |||
format combobox in userform to accept dates | Excel Worksheet Functions |