View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Vaughan Michael Vaughan is offline
external usenet poster
 
Posts: 71
Default Calendar ToolBox in a UserForm

Hello Everyone,

I have created a userform that displays the Calendar so that when I click on
it, it will input the date in a Active Cell.
Private Sub Calendar1_Click()
ActiveCell = Calendar1.Value
End Sub

Now, my question is: I don't want to put the date that I click on in an
Active Cell, that works fine. I want to be able to put the date in another
userform. I have another userform that requires a date entry: date1 How
do I click on my calendar and have it go to the Textbox (date1) in my other
Userform??? Is this possible??

Thanks.. mv