I have a userform that gives allows me to enter a description in a textbox and then it allows me to select expense or income then it places that info in the a new column that i adjacent to a specified column that contains a formula I have created on my spreadsheet to calculate the entry.

I wounld like to add a calendar to my userform that will also allow me to add the date to the userform entry. Some dates maybe future some dates maybe past but I would like to be able to look at my spreadsheet and see that:

081405
mortage

And it is fine if the date appears in description cell or I would prefer that it was in the cell above the description.

I have no earthly idea on how to do this!

Please provide detailed instructions on this on.

current code is
Private Sub CommandButton1_Click()
If OptionButton1 = True Then
Range("expense").EntireColumn.Insert
Worksheets("CGS").Cells(11, Range("expense").Column - 1).Formula = TextBox1.Value
Else
Range("income").EntireColumn.Insert
Worksheets("CGS").Cells(11, Range("income").Column - 1).Formula = TextBox1.Value
End If
Unload Me
End Sub
Thanx