Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
close calendar control form after selection
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
close calendar control form after selection
Thanks for the reply, but I am a beginner. . . .
where do i place this code? UserForm for the Calendar, UserForm for the txtbox, or under sub for the txtbox? "Hennie Neuhoff" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
close calendar control form after selection
Nevermind, I was just missing unload me.
Private Sub calendar1_Click() FormInvoice.InvDateBox.Value = Format(Calendar1.Value, "dd-mmm-yyyy") Unload Me End Sub thanks for your help "KUMPFfrog" wrote: Thanks for the reply, but I am a beginner. . . . where do i place this code? UserForm for the Calendar, UserForm for the txtbox, or under sub for the txtbox? "Hennie Neuhoff" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Form with Calendar Control - Excel 2002 to 2003 compatibility | Excel Programming | |||
How to Pass a date from a calendar control to a field on a form | Excel Programming | |||
add a calendar control in Excel form | Excel Programming | |||
Control disappeared problem - specifically, the Calendar Control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |