using the calendar on a userform

  • Thread starter Southern at Heart
  • Start date
S

Southern at Heart

wsMyWorksheet.Range("C7") = Me.Calendar1.Value
I need to have this take affect as soon as the user select a day on the
calendar. I tried putting it in
Calendar1_Exit()
Calendar1_Afterupdate()
Calendar1_Click()
....if in Calendar1_Click(), it will update the cell if the user clicks
somewhere else (in anther textbox), but if they click on a tab strip that
moves to a different userform, the date wasn't set in the cell...
 

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

Top