See

http://www.rondebruin.nl/calendar.htm


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


"crew3407 " wrote in message ...
sorry, one more thing. I think I might not have been clear enough, or I
don't know where to put the code.

when i activate the calendar, i want it to start on the current date,
but then i want to be able to select a different date. this date that
i select i am putting it into a cell in the sheet.

sub commandbutton1_click()
userform1.show
end sub

sub calendar1_click()

range("A1").value = calendar1.value
userform1.hide
userform2.show

end sub

this is how my code looks right now, so i want to be able to set the
calendar1.value initially as today's date, but then be able to change
it and have the date that i select to go into the range. Hopefully
this is clear? Thanks.


---
Message posted from http://www.ExcelForum.com/