Date Pop Up

[StompS]

I have a cell that would like a calendar pop-up to select a date as opposed
to typing it in....is this possible (and easy)? Thanks!

 

[Peo Sjoblom]

http://www.rondebruin.nl/calendar.htm

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[StompS]

I think that would work great but I have multiple worksheets and keep
creating new ones (hopefully with a macro). How can I use this and have it
be part of a new worksheet? Thanks!

 

[StompS]

I tried this on my sheet and got runtime error 424 and debugger sent me to
this line (third last on the routine)

ElseIf Calendar1.Visible Then Calendar1.Visible = False

 

[StompS]

Okay, I realized that I didn't have the calendar created in VBA. I followed
the directions, created it, and now I get a 424 runtime error "object
required' and the debugger goes to this line:
Calendar1.Left = Target.Left + Target.Width - Calendar1.Width

 

[Ron de Bruin]

Hi

Calendar1 is the name of the control

If you add more then one control you get different names

 

[StompS]

Sorry, I'm not sure what you mean...

Hi

Calendar1 is the name of the control

If you add more then one control you get different names

 

[Ron de Bruin]

Hi StompS

When You insert a Calendar the first time in your worksheet it is named
Calendar1 (see how on my site)
When you insert a second it is named Calendar2

The code looks for Calendar1 and if your Calendar have a different name it blow

You can change and see the name in the Name box in the formulabar

 

[StompS]

I'm new at this, but it appears that the calendar name is calendar1. There
is also reference to frmCalendar. I believe I followed all the directions
from your site......

 

[Ron de Bruin]

Hi

Try the steps again in a new workbook