userform calendar

[cmccabe]

Is there a way in excel 2003 to have a textbox on a userform be controlled by a popup calendar, in which a user can select a date? I can create a menu icon or a macro, but can not seem to get VBA in a userform to work. Thanks.

 

[VoG]

This may help you (you will need to adapt the code to assign the calendar value to the textbox rather than a cell) http://www.fontstuff.com/vba/vbatut07.htm