Pop-up calendar for XL 07&03

[TheMilkGuy]

Hi folks,

I'm using Office 07, but work with a bunch of guys that only use 03
(or XP, I can't remember which) and I am trying to figure out how to
make a calendar appear when you click in a cell and disappear when the
date is selected.

I found some code online, but then I had to install an XLA file that
now gives me a "Could not load an object because it is not available
on this machine" error code on startup of Excel - a little help there
would be appreciated, too.

All in all, I have never found the same caliber of solution searching
on my own that I find here.

Advice welcome.

Cheers!
Craig

 

[Dave Peterson]

I think that the calendar control only comes if you have Access installed.

But there are free versions of the calendar control (that everyone will need
installed!).

See Ron de Bruin's site:
http://www.rondebruin.nl/calendar.htm