Adding and using a calendar

this is not working.

I dont want to add the calendar as a separate userform. I have added the calender to a userform that already exists, I just need to know how to add the needed code to that userform that will allow me to select the date form the calendar and have that date added to the cell above the description.

Please view the code that I have supplied and advise.

Thanx

When you select the date in the calendar you can use this
in the CommandButton1_Click() to copy it on the cell you want

Worksheets("CGS").Cells(11, Range("expense").Column - 1).Value = CDbl(Calendar1.Value)
<<Change the range>>



--
Regards Ron de Bruin
http://www.rondebruin.nl


"oberon.black" <[email protected]> wrote in message
news:[email protected]...
>
> this is not working.
>
> I dont want to add the calendar as a separate userform. I have added
> the calender to a userform that already exists, I just need to know how
> to add the needed code to that userform that will allow me to select the
> date form the calendar and have that date added to the cell above the
> description.
>
> Please view the code that I have supplied and advise.
>
> Thanx
>
>
> --
> oberon.black
> ------------------------------------------------------------------------
> oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
> View this thread: http://www.excelforum.com/showthread...hreadid=466628
>

It works perfectly. Thank you so much for the help.