Single calendar (Userform) for multiple textboxes

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.

Cross-post: Single calendar (Userform) for multiple textboxes

try changing

Code:

---

Public cbodate As TextBox

---

to

Code:

---

Public cbodate

---

Excelfun, that recommendation by p45cal should work for you. I would also recommend using

Code:

---

Public cbodate As MSForms.TextBox

---

instead of

Code:

---

Public cbodate

---

which then makes it a variant