Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have Calendar1 on a UserForm. I'm trying to accomplish two things.
First, I would like to stop the user from selecting a date prior to the current date. I've done this using the Click event, but I have a second issue. I'd like the user to be able to use only the mouse to select the date, essentially disabling the keyboard for this purpose. The third issue is that I thought that all would be solved by using the BeforeUpdate event as in: Private Sub Calendar1_BeforeUpdate(Cancel As Integer) Figuring that if the date changed by any method (mouse or keyboard), then the BeforeUpdate event would catch it and not allow a prior date to be chosen. When I try to use the Before Update event, I get the following compile error: "Procedure declaration does not match description of event or procedure having the same name" I've looked in the object browser and used the format given. I've also searched in the NGs and the net, but have not been able to solve the problem. It appears as if I have all of the files needed to run the calendar control with the exception of the mscal.hlp file. Any ideas? TIA -- Michael J. Malinsky Pittsburgh, PA "I am a bear of very little brain, and long words bother me." -- AA Milne, Winnie the Pooh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calendar Control -- Is this possible? | Excel Discussion (Misc queries) | |||
Calendar control | Excel Discussion (Misc queries) | |||
Calendar Control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
Calendar Control 9.0 | Excel Programming |