| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar Control Not listed in Available Controls ?
How can i make this available?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calendar Control Not listed in Available Controls ?
Depends which calendar control, but the MS one is installed with Access I
believe. Others available, including the DTPicker. NickHK "Coza" wrote in message ... How can i make this available? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calendar Control Not listed in Available Controls ?
OK,
Installed MSAccess and i now have the Calendar Available. How can i get it to run when a Textbxo is Entered on a userform ? Corey.... "NickHK" wrote in message ... Depends which calendar control, but the MS one is installed with Access I believe. Others available, including the DTPicker. NickHK "Coza" wrote in message ... How can i make this available? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calendar Control Not listed in Available Controls ?
I would suggest, as a general approach:
Put it on the userform and make its visible property false. In the exit event of the userform add code to make its visible property true. -- Regards, Tom Ogilvy "Coza" wrote: OK, Installed MSAccess and i now have the Calendar Available. How can i get it to run when a Textbxo is Entered on a userform ? Corey.... "NickHK" wrote in message ... Depends which calendar control, but the MS one is installed with Access I believe. Others available, including the DTPicker. NickHK "Coza" wrote in message ... How can i make this available? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calendar Control Not listed in Available Controls ?
Are you planning to distribute your workbook? If your other users don't have
the same control installed you may have problems (I accidently did that, used the calendar control that was installed with Access and then tried to distribute my workbook to people who didn't have Access- ouch.). If this is just for your own use, ignore this :) To answer your other question, some of the more experienced folks might be able to tell you if there is an "on_enter" event for a textbox. For my application, I put a button and a label, so I (and the other users) could click the button to change the date. It brought up a second userform, sized exactly to the size of the calendar control. The selection of a date on the calendar control populated the label on the main form, and cancelling the calendar control without an entry was handled and returned a null value. HTH Keith "Coza" wrote in message ... OK, Installed MSAccess and i now have the Calendar Available. How can i get it to run when a Textbxo is Entered on a userform ? Corey.... "NickHK" wrote in message ... Depends which calendar control, but the MS one is installed with Access I believe. Others available, including the DTPicker. NickHK "Coza" wrote in message ... How can i make this available? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calendar controls | Excel Discussion (Misc queries) | |||
| Control disappeared problem - specifically, the Calendar Control | Excel Programming | |||
| Control Toolbox Controls | Excel Programming | |||
| Looping through controls on a MultiPage control | Excel Programming | |||
| Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
Linear Mode
