Single calendar (Userform) for multiple textboxes

[Excelfun]

I herewith attach sample workbook with 2 userform. i want when i click on textbox on userform the calendar should pop-up and selected value on calendar userform should reflect on textbox. I dont want to use ocxCalendar for this. here is want to user single calendar (Userform) for multiple textboxes.

I am getting error in code, i will appreciate any help on this.

[rollis13]

Cross-post: Single calendar (Userform) for multiple textboxes (http://www.ozgrid.com/forum/showthread.php?t=193084)

[p45cal]

try changing
Public cbodate As TextBox
to
Public cbodate

[Excel Fox]

Excelfun, that recommendation by p45cal should work for you. I would also recommend using
Public cbodate As MSForms.TextBox instead of
Public cbodate which then makes it a variant