PC Review


Reply
Thread Tools Rate Thread

Calendar Function

 
 
Brad
Guest
Posts: n/a
 
      9th Oct 2008
I'm building a form to allow users to sort and chart data. One of the
functions I'm trying to incorporate is to allow the user to get data from a
certain date. So when the user clicks in a text box a calendar will appear
(<- that part works) after the user selects a date, i would like to display
the date in the textbox (<-that part doesn't) any suggestions?
 
Reply With Quote
 
 
 
 
corey
Guest
Posts: n/a
 
      9th Oct 2008
Where does the Calendar date appear ?
Private Sub Calendar1_Click()
UserForm2.TextBox4.Value = Calendar1.Value ' <=== Modify to target the
required Textbox
With Calendar
Unload Me
End With
End Sub



"Brad" <(E-Mail Removed)> wrote in message
news:F451C8D9-4B5A-45F3-A511-(E-Mail Removed)...
> I'm building a form to allow users to sort and chart data. One of the
> functions I'm trying to incorporate is to allow the user to get data from
> a
> certain date. So when the user clicks in a text box a calendar will appear
> (<- that part works) after the user selects a date, i would like to
> display
> the date in the textbox (<-that part doesn't) any suggestions?



 
Reply With Quote
 
Brad
Guest
Posts: n/a
 
      10th Oct 2008
that works. thx

"corey" wrote:

> Where does the Calendar date appear ?
> Private Sub Calendar1_Click()
> UserForm2.TextBox4.Value = Calendar1.Value ' <=== Modify to target the
> required Textbox
> With Calendar
> Unload Me
> End With
> End Sub
>
>
>
> "Brad" <(E-Mail Removed)> wrote in message
> news:F451C8D9-4B5A-45F3-A511-(E-Mail Removed)...
> > I'm building a form to allow users to sort and chart data. One of the
> > functions I'm trying to incorporate is to allow the user to get data from
> > a
> > certain date. So when the user clicks in a text box a calendar will appear
> > (<- that part works) after the user selects a date, i would like to
> > display
> > the date in the textbox (<-that part doesn't) any suggestions?

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calendar overlay - printing function only prints one calendar. =?Utf-8?B?T3ZlcmxheWVk?= Microsoft Outlook Calendar 0 12th Feb 2007 06:59 PM
Help Using Calendar Function =?Utf-8?B?RGF3bg==?= Microsoft Excel Misc 4 1st Apr 2006 04:09 PM
Calendar Function Tom Microsoft Excel Worksheet Functions 10 20th Apr 2004 10:39 PM
Calendar Function Tom Microsoft Excel Worksheet Functions 0 20th Apr 2004 06:06 PM
Calendar Function Chrissy Microsoft Access 0 23rd Oct 2003 01:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:34 PM.