Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default Calendar Control issues

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calendar Control -- Is this possible? Steve Excel Discussion (Misc queries) 2 December 29th 06 10:58 PM
Calendar control Shane Excel Discussion (Misc queries) 2 January 30th 06 06:20 PM
Calendar Control Neil Excel Programming 3 May 27th 04 01:02 PM
Calendar Control: Can't exit design mode because control can't be created Rone Excel Programming 0 May 24th 04 04:01 PM
Calendar Control 9.0 Brad[_10_] Excel Programming 3 December 15th 03 06:39 PM


All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"