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" wrote in message
...
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" wrote in message
...
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?