I have user form with text box to enter date. The entered date should be converted into excel number
Same as using in excel cell
ActiveCell.FormulaR1C1 = "12/12/2011"
Range("C5").Select
Selection.Style = "Comma"

is there a function to do that. Converting the date entered into text box (12/12/2011) to 40889.

Please help me