Solved: Calendar control not working

[shades]

I won't be able to try this on the Mac until this evening. But looks good in XL 2003 on Win 2K.

[Richardall]

Bluecactus, Thank you again for all the help. In one of your original replies, you mentioned that you couldn?t upload the file. Has that changed? Can you wrap this up and post it. I did what you said and I'm having some success, but...



Was wondering?



Thank you again.

[BlueCactus]

Bluecactus, Thank you again for all the help. In one of your original replies, you mentioned that you couldn?t upload the file. Has that changed? Can you wrap this up and post it.

Here you go. This one contains mode 0 and mode 1 listed above.

You can look at the file, but to use it in VBA requires code like:

Load DatePick
Call DatePick.FillVars
DatePick.Show

Options are through...

DatePick.FillVars(defaultSelection, mode)

defaultSelection (optional, type Date) is the default date to be returned. If unspecified, Date (i.e., today's date) is used.

mode (optional, type Integer) is either 0 or 1 (default 0) in this revision.

mode 0: date returned immediately on clicking a day.
mode 1: date displayed on form when selected. Returned when user clicks 'OK' button. Allows user to select a date and hunt around the calendar some more before confirming the selection.

[7/7/05: File updated to fix a few minor cosmetic issues on Win VBA]
[7/7/05: File removed. Replaced with post #23]