close calendar control form after selection
If it's on a userform - something like this;
With [userformname].Calendar1
activecell.NumberFormat = "dd-mmm-yy"
activecell.Value = .Value
End With
Unload [userformname]
???
--
HJN
"KUMPFfrog" wrote:
I have a calendar popup upon TextBox1_Enter (). I select the date and it
fills the textbox in, but i want the popup to disapear after that or when
mouse moves off the calendar area.
|