code to connect textbox1.text with calendar control selection

**shankar.nstl** · 09-06-2011, 01:25 AM

On the userform of a workbook, I placed a Textbox and also a Calendar Control. Pls suggest me the code to transmit the selected date in Calendar control tool to the Textbox1.

Thanks in advance.

**john55** · 09-06-2011, 04:33 AM

hi,
see if the teh Roy's calendar helps you.

**royUK** · 09-06-2011, 07:52 AM

You could adapt that code for an activeX calendar control, but the main reason for building the userform is that not all computers calendar control is not available on all computers

**shankar.nstl** · 09-06-2011, 08:55 AM

yes sir, i too observed it now. is there any solution. Actually in Visual Basic, if we made a project into package, all the controls will be worked on the installed PC even it wont have that facility. Is there any way like in excel also ?