Moving values from one form to another
Posted on 2006-05-01
Hoping somebody can help me out here. I'm working on some forms in Excel. One's a data input form and the other's a calendar.
I've got several controls that take dates as input. In the enter event for each control, I want to be able to open the calendar, pick a date, and return the date to the control that I originally clicked. I can do it manually pretty easy within the calendar:
Form.controlname.value = Calendar1.value
The problem is I have punch in the specific name of the control. Your thoughts?