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

[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