I need the calendar to update the TextBox

I think that's the wrong approach. You should have the calling form update
itself.

--
Jim
"Trevor Williams" wrote in
message ...
|I have 2 forms. Both forms have a button that calls a calendar control.
|
| The calendar Close Event is set to update a TextBox on UserForm 1 - which
is
| fine if UserForm1 is open.
|
| I need the calendar to update the TextBox on the form that is currently
| open. Is there a function like 'ActiveForm' that I can use?
|
| Thanks
|
| Trevor Williams