Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar Control - closing out
Hi - I'm a newbie with VB programming, so this may be a simple
solution which I'm just missing, but.... I'm using the Calendar Control version 11 within my spreadsheet to allow a user to select a date for a specific cell. I have set up the form to become visible once a button is clicked. Afterwards, I'm trying to put code inside the AfterUpdate() sub which will close the Calendar Control (or at least make it not visible). My code is ery simple: Private Sub frmCalendarBox_AfterUpdate() frmCalendarBox.Visible = False End Sub The bad news is that this isn't working. Any thoughts??? PS - I also tried to trigger the close based on the value in my taget cell (F6) being changed. For this I used the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Range("F6").Value 1 / 1 / 2006 Then frmCalendarBox.Visible = False End If End Sub But no luck with that, either. Any help someone could give would be appreciated!!! Thanks, -Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar control | Excel Programming | |||
How do I keep Calendar Control from closing? | Excel Programming | |||
Control disappeared problem - specifically, the Calendar Control | Excel Programming | |||
Closing form turns off commandbar control procedures?? | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |