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?

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?

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?
>
>
>