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

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

081405
mortage

And it is fine if the date appears in description cell or I woul
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

Code
-------------------

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

-------------------


Than

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46662