M
Michael Malinsky
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
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