how to insert pop up calendar in Excel 2003
 

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?

how to insert pop up calendar in Excel 2003
 

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

"sboyd" wrote in message
...
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?

how to insert pop up calendar in Excel 2003
 

Hi,

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

ActiveSheet.OLEObjects.Add(ClassType:="MSCAL.Calen dar", 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

"sboyd" wrote in message
...
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?