one calendar fills data to different textboxes

**NonSira** · 07-17-2010, 07:43 AM

Hello everyone,

I created 2 identical worksheets with the different names "RSV" and "INH" and I copied every controls on from UserForm "frmRSV" to "frmINH".

There are 2 buttons to call calendar "cldADAT" and "cldDDAT". When I clicked on the calendar, I wanted the data to be displayed in "frmINH.txtADAT", but it wasn't.

I've attached the file I'm working on, please help me out.

Thanks

Nontpakorn

**MickG** · 07-17-2010, 12:27 PM

Hi, You have 2 userforms That both use the same Calendars code.
You can't use a code in a Userform that Relates to another Userform.
When your working with Userform "frmINH" The Calendar Code relates to Userform "frmRSA".
You could probably get away with removing the Reference in the Caledar to the Userform, and just relate to the TextBox.
Mick