Userform Combobox dropdown to show date format...

[pedie]

I have Userform Combobox dropdown which shows date format but when i select the drop down the Combobox value shows general number format why?
Otherwise everything is okay.

Please suggest!
Pedie

 

[pedie]

B.U.M.P. Hi

 

[diddi]

how have you populated the combobox

 

[pedie]

how have you populated the combobox

I do not have UserForm_Initialize code...I have linked the combobox value to b3 thats all. and the row source is from range(A1:A10) the drop down shows format of date in 1-Jan etc but when i select the drop down it dislays in combobox as = 40176

Private Sub ComboBox1_Change()
Range("B3").Value = ComboBox1.Value
End Sub

 

[MickG]

Try:-

Private Sub ComboBox1_Change()
ComboBox1.value = Format(ComboBox1.value, "dd-mmm-yyyy")
End Sub

Mick

 

[pedie]

Hi Mike, I have tried this code myself but it still won't give me the result in that format.
Thanks
Pedie

 

[pedie]

Sorry Mike....it is working. my bad

Thanks alot!