J
jml
I would like to insert a small calendar in the top right corner of a worksheet.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul B
jml, see if this will do what you want,
http://www.fontstuff.com/vba/vbatut07.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
http://www.fontstuff.com/vba/vbatut07.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
worksheet.jml said:I would like to insert a small calendar in the top right corner of a
C
Conrad Carlberg
There's a very useful Calendar Control, an ActiveX, that has shipped with
Excel ever since Excel 97. In older versions you had to specify that you
wanted it during the installation routine; now (say, XL 2002 and later) I
_believe_ that it's installed by default. To get at it, assuming that it's
been installed, choose View | Toolbars | Control Toolbox. The final icon in
that toolbar has an image of a hammer, a spanner wrench and an ellipsis.
Click on that icon to get More Controls. You should find one (they're listed
in alpha order) named Calendar Control; its version number depends on the
Excel version you're running. Click it and when you move your mouse pointer
back over the worksheet it will turn to a crosshairs. Click the mouse button
and drag down and right to locate the calendar.
It's a little tricky to work with this control, but once you've got it
figured out it's a splendid way for users to specify dates. A client of
mine, a hospital, has been using it to schedule rooms for the past six
years, without a problem. No, not even a user error -- it's that easy to
use.
C^2
Conrad Carlberg
Excel ever since Excel 97. In older versions you had to specify that you
wanted it during the installation routine; now (say, XL 2002 and later) I
_believe_ that it's installed by default. To get at it, assuming that it's
been installed, choose View | Toolbars | Control Toolbox. The final icon in
that toolbar has an image of a hammer, a spanner wrench and an ellipsis.
Click on that icon to get More Controls. You should find one (they're listed
in alpha order) named Calendar Control; its version number depends on the
Excel version you're running. Click it and when you move your mouse pointer
back over the worksheet it will turn to a crosshairs. Click the mouse button
and drag down and right to locate the calendar.
It's a little tricky to work with this control, but once you've got it
figured out it's a splendid way for users to specify dates. A client of
mine, a hospital, has been using it to schedule rooms for the past six
years, without a problem. No, not even a user error -- it's that easy to
use.
C^2
Conrad Carlberg
worksheet.jml said:I would like to insert a small calendar in the top right corner of a