Hi,

I have a UserForm with about 80 controls filling a datasheet, works fine, now I would like to use the Calendar control to help the users to enter Dates. I have about 7 TextBoxes on the form to enter Dates and I thought a separate UserForm would be opened at DblClick event on those TextBoxes which are supposed to be used for Date entries into the database.
So far so good, I have made up that second UForm and the event opens it up no problem.
I have however the difficulty to get the selected Date into the respective TextBox and in to the database.
It seems as though I can only solve this if I make up as many Uforms as many TextBoxes I want to enter dates.
There must be a better way.
Any help would be much appreciated.

Gabor