I've got my form with TextBoxes and I've got my calendar.
I've even got the thing loading all the necessary fields into the right
cells in a new correctly formatted row on my worksheet.
All of this thanks to posts I found here - I've learnt so much in the last 2
weeks!

Three of the textboxes on this form need to take dates. How can I tell the
Calendar which of the three to send the data to ?
My solution:
Three separate calendars (and CommandButtons to send the Value) that only
become visible when the cursor enters the relative textbox. i.e. Calendar1
appears when entering TextBox1 then disappears after its button is clicked,
Calendar2 appears later on when entering TextBox2 etc. I could place them all
in the same position so to the user it'd look like the same calendar
appearing each time. I certainly don't want three calendars filling my form!

Is there a more direct way ? Some property of textBoxes like "HasFocus" or
"IsActive" that I could use ?