Thread
:
Why does the date change from "January 07" to a numercial value of "39038 "
View Single Post
#
1
Posted to microsoft.public.excel.programming
Corey
external usenet poster
Posts: 363
Why does the date change from "January 07" to a numercial value of "39038 "
Private Sub UserForm_Initialize()
With Sheet1
Me.ComboBox1.RowSource = "B17:B28"
Me.ComboBox1.Text = Format(Me.ComboBox1.Text, "mmmm yy")
End With
End Sub
Reply With Quote
Corey
View Public Profile
Find all posts by Corey
Why does the date change from "January 07" to a numercial value of "39038 "