Calendar form

[Patrickw]

I've given up on the various calendar ocx controls. They are flakey
and I can't depend on them being installed and registered on other
machines. What I would like is a userform I can pop up over my main
userform that will look like a drop down calendar control. If there
is such an animal (and I think there are such solutions), which one is
best? Thanks.

 

[Patrickw]

I re-run 'regsvr32 mscal.ocx', to no avail. The message box says the
registration is successful.

 

[Graham Mayor]

See http://www.gmayor.com/popup_calendar.htm which explians how to use it.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Patrickw]

Thanks. That'll work.

 

[Graham Mayor]

Incidentally I believe I misled you about the default date for the DTPicker
in an earlier post. You can set the start value of that as follows

Private Sub UserForm_Initialize()
DTPicker1.Value = Date
End Sub

or ... e.g.

Private Sub UserForm_Initialize()
DTPicker1.Value = Date + 30
End Sub

Apologies!
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[ker_01]

For what it's worth, I had a project a few years ago where we were trying to
use the VBA calendar controls (on a small, appropriately-sized userform).
There were two available on our department's PCs, so we picked the nicer one-
only to find out that it was available on newer versions of office and any
machine with Access installed, but not available on older versions that also
didn't have Access. We ended up switching to the 'other' control, after which
we had no problems. That was an employer and several years ago, so I don't
recall which control it was, but if you develop on the absolute minimum
version and PC image at your company (or among your customers), I've not
found anything on the calendar controls that wasn't /forward/ compatible.

The three that are listed in my current 2003 install are:
Calendar Control v11
MS Date and Time picker v6
MS Monthview control v6

but I also have Visio2007 and a variety of other items installed, so I'm not
a good model for a minimum installation, especially if any of your users are
still on 97 or pure 2003.