how to insert pop up calendar in Excel 2003

[Guest]

I am working in an Excel 2003 worksheet and need to insert pop-up calendars
(for selecting and inserting start and end dates). I have no VBE experience.

Various downloadedVBE Instructions seem simple enough (albeit many-stepped)
and no instructions have been specifically for Excel 2003. All my calendars
fail, then ask if I want to debug, then highlight the line frmCalendar.Show
in the screen that reads:
Option Explicit
frmCalendar.Show
End Sub.

Can anyone give me instructions that work?

 

[Paul B]

sboyd, have a look here

http://www.rondebruin.nl/calendar.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

 

[Charles Harmon]

Hi,

If your putting the Calendar on the spreadsheet then this recorded macro
should work

ActiveSheet.OLEObjects.Add(ClassType:="MSCAL.Calendar", Link:=False, _
DisplayAsIcon:=False).Select
paste to a module.

If you want a Calnedar on a userform. Then you need to create a userform and
the Right click on the Toolsbox scrol down and select calendar control 9
select it and a icon will be on the Toolsbox. Click it and click on the
userform. The Calendar will be displayed on the userform. Now you can put
this in a module:

Sub mycalendr()
UserForm1.Show
End Sub
This will display the userform with the Calendar.

Charles