MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combobox problem

Posted by zen on June 26, 2001 4:37 PM

i've got userform with a combobox on it, the data for the box is on the sheet, x1:x31 which is custom date values "dddd mm dd yy", in the combo box it's default at formula(now(), "dddd mm dd yyy"), when i call up an item from the list it is converted back to the General Number format, how do i get vb to change it into the format i require??

thanks in advance


Posted by Russell on June 26, 2001 9:48 PM

You can do something like this:

Private Sub ComboBox1_Change()
ComboBox1.Value = Format(ComboBox1.Value, "dddd mm dd yyyy")
End Sub

Hope this helps,