LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
control toolbox and userform toolbars in XL 03 Dave F[_2_] Excel Discussion (Misc queries) 2 August 8th 07 08:04 AM
UserForm Toolbox displaying Otto Moehrbach[_6_] Excel Programming 3 October 17th 04 12:47 AM
calendar userform peter Excel Programming 3 June 16th 04 06:11 PM
Calendar in UserForm cogent Excel Programming 4 May 14th 04 02:01 AM
Calendar in UserForm Soniya Excel Programming 2 August 27th 03 05:24 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"