Calendar Function

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

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
 
that works. thx

corey said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top