View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] brotherescott@yahoo.com is offline
external usenet poster
 
Posts: 18
Default Passing a value from 1 userform to another when you dont know who called it.

I have a user form that has several date entry TextBoxes. I have a
generic calendar userform that I call when one of the date text boxes
is selected. Basically I have a quote input form. I have text boxes to
capture the Date the request was sent, the date it was expected and the
date it was received. When I click on one of these text boxes my
generic calendar user form pops up and the user selects the date then
hits a enter date button. This is where my problem comes in. How do I
know where to return the date to? TextBox1,TextBox2, TextBox3.....? Is
there some way for the "Enter Date" button on the calendar userform to
know who invoked it and return the date to the correct text box? The
"Enter date" button code resides with the calendar user form not the
"Quote Request" userform that it was called from.

Thanks
Scott